Sign in to join the conversation:
I want to create an if statement in my % complete column such that % complete goes to 100% when another column has a date.
Try (Change Due Date to your column name):
=IF(ISDATE([Due Date]@row), 1, 0)
Thanks! It works if I eliminate any dependency for the %change column.
Hi Community I have a check box column with a column formula to check if the Start Date and End Date are Todays Date. =IF(AND(ISDATE([Start Date]@row ), ISDATE([End Date]@row ), [Start Date]@row <= TODAY(), [End Date]@row >= TODAY()), 1, 0) This works when there is a date range, ie Start Date is 18/2/26 and End Date is…
I'm new to Smartsheets and attempting to transfer tracker data from Google Sheets to build dashboards. I use emojis in trackers and COUNTIF formulas to summarize the data based on emoji categories. The formulas work as long as there is no other data in the cell but I get a "0" if there is any other text in the cell. Please…
I’m trying to build a formula that can achieve the following logic, but I’m struggling to get it working correctly. I have a data sheet with around 100 project rows. Each row contains a Fab Start date and a Fab Finish date (along with many other fields). Some projects run across two consecutive months. In my metrics sheet,…
