I can sort of see my mistake but not sure how to come at it a different way to correct it. What i am trying to ask is “Is the job booked in date, within the previous 7 days of today ? Is the Job booked in Today? Is the Job booked in within the next 7...
I am looking at attempting to combine the two functions into a single input. The second is to catch jobs that go overdue earlier.
Original Question: Formula to track days past a set date, multiple outputs
Justin Barret provided this code:
IF( ...
I keep trying to google, search and i am not landing on what i need. My coding understanding, as minimal as it is, is only enough to get me into trouble.
As a general expression of what i wish to achieve; i want to make a view, that shows items::
are...
This is where I got to and it is obviously wrong. I am really trying to have a singular output so I can do more with it. I put the screenshot below because I can’t figure out formatting on this forum.
IF(
AND(
NOT({Work Completed}),
...
