Sign in to join the conversation:
I trying to write a formula if (Days)<=30 will display an Amount in column 0-30
=if([Days t]1 <=30,Amount1,"")
Hi everyone! The below formula is not populating a 0 in cells that are new, as intended. The AI tool even says this formula should work, but it's not. After staring at it for hours, I can't figure out where I'm going wrong. Your help would be greatly appreciated!! Thanks! :) =IFERROR([Date Logged]@row - MAX(COLLECT([Date…
Occasionally I have been getting #ERROR or other error messages as a formula result in cells that previously return a valid result, and nothing related to that cell or the cells that are referenced changed. The only thing that finally fixes this is to do a hard page refresh. The attached images show this, and the only…
Hi all, I have a bunch of underlying sheets that have the exact same setup due to a template and it has a status field with a drop-down of about half a dozen different options that go sequential order from not started to complete and verified as complete from leadership. We also have hierarchy so there is level 0, 1 and 2…
