Sign in to join the conversation:
Im putting this formula into a cell in a date/time property column and it returns the text "=Today()" ie with no functionality.
Hi,
If you have activated Dependencies for the sheet and trying to input it the formula in the Start or End date it will not work because you can't use formulas in those columns when dependencies are enabled but, you can type a "t" instead, and today's date will be added.
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Are you trying to edit a sheet or a report? Reports allow you to update data in the source sheet where the data originates but you can't enter a formula through a report. It would do exactly what you describe, display the formula as text with no functionality.
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I looking to find unique values, in order, and separate them into columns. The "Client Update Date" column will contain dates, not in order and some dates may be duplicated. In the "1st Date Feedback I'm getting the correct date of 12/12/25 with the formula: =MIN([Client Update Date]:[Client Update Date]) In the "2nd Date…
