-
Auto checkbox formula for a date
I'm looking to have a checkbox column be automatically checked off whenever the date column next to it is filled in...here are the two column names: SQV Scheduled - checkbox formula SQV Date - date column (next to it) This is the formula I have: =IF(ISDATE([SQV Date]@row, 1, 0)) It's not working :( help!
-
Parent row possibility?
I have an idea but I'm not sure it's possible, need some advice. I have a form I've created with an option to add 5 submissions. I need to be able to total these submissions based on who filled out the form. Right now I have a helper column that adds the submissions up that are on the row, but I wondered if I couldn't set…
-
Concatenate Integer + Words?
I work in events. I group my tasks by how many months out the task is from the event date (1 month out, 2 months out, etc.). I'm wondering how I can create the `1 month out from event` in field using a formula. I'm coming from the world of Airtable where I could calculate how many months a Due Date was from an Event Start…
-
Please help me correct this formula!
=IF(AND([% Complete]@row < 0, [Start date]@row < TODAY(), "Not started", IF(AND([% Complete]@row > 0, [Start date]@row > TODAY(), "In progress", IF(AND([% Complete]@row < 100, [End date]@row < TODAY(), "Overdue", "Complete")))))) Hi - I've created this formula but getting the "INCORRECT ARGUMENT SET" error message. I think…
-
Adding another layer to my report formulas i.e. another way to group the statements
I'm trying to filter a report with multiple levels of filtering, however, I can't seem to find a way to add the last level. I have 4 groups of AND statements bound together by an OR, but I need to add another AND that binds that whole previous statement together. I want Record type is equal to "Opportunity" to apply to all…
-
Automatically Added rows
I have finally gotten my formulas to work (thank to this community) but have noticed they keep "breaking". I figured out that when my sheet refreshes, and the rows are automatically added and the bottom of the sheet, the formula is looking at the blank cells and then I get an error message. I have tried multiple way to…
-
Is there any possibility for Index Match to search multiple ranges?
We currently are doing a reorg in my department and now AVPs (where once only having managers as direct reports) have both admin and managers and in turn, will affect certain columns and reports that they view. Is there any possibility for Index Match to search multiple ranges if first range found nothing? or suggestions…
-
COUNTM not working
Hello community, I have a formula to count distinct values in my column. However, it is not working how I'd like it to. This is the formula with the image below that it relates to: =COUNTM(DISTINCT([19th Mar]3:[19th Mar]60)) The number of counts is 5, but it should be 3 because 'FG' 'BK' are repeated. I assume it's not…
-
Count Day Between IF
I am looking to count the days between two columns, if a third column meets criteria. Compare Due Date and Collection Date, counting the days between if Test Type is "Random"
-
Duration Formula, if End Date is Blank, use Today's Date, if not, use End Date @ row
I'm struggling to update an existing formula in our Smartsheets. Currently, we calculate the duration of a task by using this formula: =([End Date]@row - [Start Date]@row) The issue is, if the end date is blank because the task is not complete, the duration is blank. I'd like to update it to use the existing formula AND if…