or Explore Discussions

# Formulas

## Discussion List

• PLANNED VERSUS ACTUAL PROGRESS
In Archived 2015 Posts
hi,   is there a way that i can see the planned versus actual progress of the project ? baseline versus actual?   thanks.
1711 6
Closed 1.7K views 6 comments Most recent by JamesR Archived 2015 Posts
• Difference in Days between Projected & Actual Start Dates/ End Dates?
In Archived 2016 Posts
My managers want a column that calculates number of work days (Mon. - Fri) between Projected Start Date and Actual Start Date. Example: Projected Start Date (in Column A): 09/01/16. Actual Start Date (in Column C): 09/09/16. Difference in …
98 1
Closed 98 views 1 comment Most recent by George Heckert Archived 2016 Posts
• Using a formula =CONTACT wont populate actual contact info subtasks
In Archived 2016 Posts
Help! At the top of my projects, I am including the resources involved.  I'd like for subtasks to be auto-populated when I fill in a resource.  Example: in my resources section, I set the HL7 Engineer to Joe Downing.  I have it set so all …
3 1
Closed 3 views 1 comment Most recent by JamesR Archived 2016 Posts
• Web forms and formulas
In Archived 2016 Posts
Good afternoon, I have a simple sheet for a balance sheet, and I'm needing to know if there's a way for the web form submission to be included in the formula in my sheet. The last row & column of the sheet houses the formula from p…
26 1
Closed 26 views 1 comment Most recent by Kennedy Stomps Archived 2016 Posts
In Archived 2016 Posts
Hi   Does anyone know if there is a way to time stamp any comments placed into a sheet?  I know you can always look at the history of the cell but I was wondering if there was any way that the date would automatically be placed in the ce…
94 8
Closed 94 views 8 comments Most recent by Kennedy Stomps Archived 2016 Posts
• Need help making a COUNTIFS NOT formula
In Archived 2016 Posts
Hi there - I want to count how many times column A shows Katie and Column B does NOT show "Completed" looking at a range of rows - I have no idea how to make that happen :(   I can do the COUNTIFS over and over again for all th…
849 2
Closed 849 views 2 comments Most recent by Katie D Archived 2016 Posts
• Result look up
In Archived 2016 Posts
Hi,   I am a beginer at using Smartsheet however have been successful to date in creating a workable module for my sales team, however, within one of my module sheets I have a list sales attributed to sales staff which uses a Decision dr…
11 2
Closed 11 views 2 comments Most recent by Tony Davidson - SmartSheet Certified User 2016 Archived 2016 Posts
• Count children rows only if items are not marked complete
In Archived 2016 Posts
I have a parent with 22 children. I can use a simple formula to calculate the total number of children ="Site-Wide" + " (" + COUNT(CHILDREN()) + ")"   What if I only want to count the children that haven't b…
37 1
Closed 37 views 1 comment Most recent by Reema Hussain Archived 2016 Posts
• sorting by row ID
In Archived 2016 Posts
Dear Smartsheet users Community members,    can someone answer to my pretty basic question. i have a challenge to sort the table back to initial order per Row ID (1,2,3,4,5,6,7....) after sorting based on some other column info (e.g. dat…
58 2
Closed 58 views 2 comments Most recent by Zafar Yuldashev Archived 2016 Posts
• Time Function
In Archived 2015 Posts
Imported an Excel sheet that calculates end times for tasks as a start for a Smartsheet.  The intent is that we give a start time for the day, number of appointments needed and it builds a schedule, which I can then link with other Smartsh…
188 3
Closed 188 views 3 comments Most recent by Mariana Archived 2015 Posts