Date formula - Return Sunday for every week
I have a formula Date field called Week end date. I need to set it to Sunday of the current week. For example if today is wednesday 5/20/2020 the week end date should be set to 5/23/2020. It needs to calculate from date created field. If this is not possible can I need to base it off from another date field, called week start date. A user selects the start date and according to the selection the week end date should be the coming Sunday of the week start date. Can anyone help on the formula? ------------------------------ Raj Helaiya ------------------------------
Arrange order of field choices
Hello. I have a table containing different projects with each having 12 months and a corresponding value for each month. Then I set up this lookup field Month which is areference proxy from that table and while the order of months is "ascending", I would like this Month field to show the order from January to December regardless of the project chosen. Can you please help with this? Should I add a formula on the form? #Tablesandfields #formulas #FormRule ------------------------------ Ma. Isabel Gumanid ------------------------------
