-
Automate [Actual Finish] based on when [% Complete] reaches 100%
I can't trust taskees to update [Actual Finish] reliably, so automation seems to be the key. I want to automate [Actual Finish] based on when [% Complete] reaches 100% I have really tried to bang my head through this, but to no avail. I keep running into endless updates of [Actual Finish] or #CIRCULAR REFERENCE issues.…
-
Countifs with AND/OR
Hi There I have a Countifs that is counting the number of projects that are healthy (Green), marked as "prioritized", are "in progress" and match a particular category. This works great, except I'm trying to expand this to look for "in progress" projects OR "not started" projects, but maintain all the other AND criteria..…
-
If statement % complete column
I want to create an if statement in my % complete column such that % complete goes to 100% when another column has a date.
-
IF and OR Formula
Hi, I am trying to write a formula that returns a flag if one of column 1,2,3,4,5,6,7 isn't checked. I have tried using the IF and OR formula together but am getting #Unparseable. Any ideas/help will be appreciated. Thanks
-
Drawing row linked data into another sheet together?
Hi All! So I have a sheet with a list of tasks, a checkbox for completion and a due date. In one of my other metrics sheet, I am trying to generate a list of my top 5 overdue tasks. I have managed to get a list of the most overdue dates with a SMALL(COLLECT...) function which will only count dates that are not listed…
-
Calculation Formulas on Reports
Our company uses Smartsheet a little differently than most but I am finding it would be very helpful if I could add formula calculations directly to the reports I pull. Currently I have to add the formulas to the sheets themselves, hide those columns and continue dragging formulas down as we add rows. Hundreds of sheets...…
-
Formula Refers to Worng Row
I have a SmartSheet that was created with nothing assigned to the primary collumn. This means many email notifications have no reference to what row or item it refers to. So, I added a formula to concatenate other collumns into the primary: =ID1 + " - P/N " + [P/N or Item #]1 + " " + Client1 + ", " + [Short Description]1…
-
Auto-filling formulas in Sheet w/ Salesforce Connector
Hi All, I have a sheet that is connected to Salesforce opportunities using the Smartsheet-Salesforce connector. I'm trying to find a way to get my formulas to auto-fill in columns that exist in Smartsheet, but not in Salesforce when a new opportunity is added to Salesforce and subsequently populates the sheet in…
-
Formulas
NETWORKDAY/S Can why does this formula above give out different numbers when the start and end date (automated by column) are the same. Eg... =NETWORKDAYS(Date created, Date modified) = no of days Date created column = 01 august 2019 (tues), Date modified column = 01 August 2019 (tues) = 1 On the next line it will say Date…
-
Combining IF formulas to Return Text Values
I have 3 columns; Start Date, End Date, Progress I can get the following formulas to work separately for row 17: =IF([Start Date]17 < TODAY(), "In Progress", "Not Started") Returns in the Progress column =IF([End Date]17 < TODAY(), "Overdue") Returns in the Progress column. I want to combine these 2 formulas in one cell to…