Formula stops working when changing name of column
Greetings-
I have the following formula that tells me what day of week a specific date is if the date column is called "Date". If I try and change the formula to reference a column called "Date of Program" the formula doesnt work anymore. Why is this? How can I make it work with a date column called Date of Program instead of just Date? I updated the formula to say (Date of Program@row) but that doesnt do it. Thanks for any info. MD
WORKS
=IFERROR(IF(WEEKDAY(Date@row) = 1, "Sunday", IF(WEEKDAY(Date@row) = 2, "Monday", IF(WEEKDAY(Date@row) = 3, "Tuesday", IF(WEEKDAY(Date@row) = 4, "Wednesday", IF(WEEKDAY(Date@row) = 5, "Thursday", IF(WEEKDAY(Date@row) = 6, "Friday", IF(WEEKDAY(Date@row) = 7, "Saturday"))))))), "")
Doesnt WORK
=IFERROR(
IF(WEEKDAY(Date of Program@row) = 1, "Sunday",
IF(WEEKDAY(Date of Program@row) = 2, "Monday",
IF(WEEKDAY(Date of Program@row) = 3, "Tuesday",
IF(WEEKDAY(Date of Program@row) = 4, "Wednesday",
IF(WEEKDAY(Date of Program@row) = 5, "Thursday",
IF(WEEKDAY(Date of Program@row) = 6, "Friday",
IF(WEEKDAY(Date of Program@row) = 7, "Saturday"))))))), "")
Best Answer
-
Since there is a blank space in the title, you need to add brackets around the column name [Date of Program].
If you update where you have that name to the bracketed name, it should resolve.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
Answers
-
Since there is a blank space in the title, you need to add brackets around the column name [Date of Program].
If you update where you have that name to the bracketed name, it should resolve.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
-
That worked! Thank you for the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
- Hi, I'm looking to write a formula using references to a rate sheet (screenshot attached with sensitive information redacted). We have several types of rates here, and also ones that are per word, whi…
- Is anyone able to help with the formula to Index Match the SO Number column and return the lowest date listed in the "finished date" column into the "first date" column? I can make it work when select…