Keep Getting Invalid Value for this Formula

kaowser

Hi,

If someone proficient in smartsheet can help me out on this. I keep getting #invalid value for my dates that I enter from January to March. But from April onward the (target submittal dates appear).

=IFERROR(DATE(YEAR([Project Start Date Tentative]@row), MONTH([Project Start Date Tentative]@row) - 3, DAY([Project Start Date Tentative]@row)), DATE(YEAR([Project Start Date Tentative]@row) - 1, 15, DAY([Project Start Date Tentative]@row)))

kaowser

chatgpt helped me. had to change the day from 15 to 9.

=IF(MONTH([Project Start Date Tentative]@row) > 3,
DATE(YEAR([Project Start Date Tentative]@row), MONTH([Project Start Date Tentative]@row) - 3, DAY([Project Start Date Tentative]@row)),
DATE(YEAR([Project Start Date Tentative]@row) - 1, MONTH([Project Start Date Tentative]@row) + 9, DAY([Project Start Date Tentative]@row))
)

kaowser

chatgpt helped me. had to change the day from 15 to 9.

=IF(MONTH([Project Start Date Tentative]@row) > 3,
DATE(YEAR([Project Start Date Tentative]@row), MONTH([Project Start Date Tentative]@row) - 3, DAY([Project Start Date Tentative]@row)),
DATE(YEAR([Project Start Date Tentative]@row) - 1, MONTH([Project Start Date Tentative]@row) + 9, DAY([Project Start Date Tentative]@row))
)