Share
Report
74Hi all,
I am trying to create a textbox that displays the current location which is in my Sharepoint list. The column in my Sharepoint list contains a formula that is based on other columns: Monday(date), Mon Location, Tues(date), Tues Location, . . .
The formula I wrote is currently not working properly. The logic makes sense but I feel like there is an error somewhere. Would you mind looking over it and see if you can catch anything? MS Lists doesn't highlight the incorrect parts.
Thank you!
=IFERROR(IF(DATEDIF([Monday], Today(), "D" = 0), [Mon Location]),IF(DATEDIF([Tuesday], Today(), "D" = 0), [Tue Location]), IF(DATEDIF([Wednesday], Today(), "D" = 0), [Wed Location]), IF(DATEDIF([Thursday], Today(), "D" = 0, [Thu Location]), IF(DATEDIF([Friday], Today(), "D" = 0), [Fri Location], "Not current or applicable")
All responses (
Answers (
