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.
Hello, I have a data tracker that has a column with different company names. It is a free text column from a form. In my calculation sheet, I need a formula to pull in those company names from the data tracker. Is it an Index or VLookup formula? Thanks in advance.
Hi, I have a SS Form to capture my team's attendance on a daily basis, specifically the dates, leave type. I am capturing the employee's name using the Contacts type field in the form. Now, on the form, when I make an entry for a specific name, dates and leave type, is there an option to detect if the same entry was…
The formula has been corrupted and all we have are 0's. They are in our PO Expenses but not syncing with the job.
