-
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…
-
Formula that Automatically changes Date when cell changes
Is there a formula that would automatically change its date to reflect the date a cell or column changes? For example, I am creating a sheet where I want a formula that changes its date to reflect anytime someone changes the task, so the person changing the task's status doesn't have to change the date they updated the…
-
Report and Dashboard View of Planned vs Actual progress Task
I have searched the community for some solutions for what I am trying to achieve…and there were lots of information that seemed close to what I am trying to do. Many links that were shared for other blogs, articles, etc., are no longer active. So I am hoping someone from the community can help me put it together. We would…