-
PLANNED VERSUS ACTUAL PROGRESS
hi, is there a way that i can see the planned versus actual progress of the project ? baseline versus actual? thanks.
-
Difference in Days between Projected & Actual Start Dates/ End Dates?
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 Days between projected and actual start dates (Column B) : 6 Days. What formula would…
-
Using a formula =CONTACT wont populate actual contact info subtasks
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 HL7 tasks then populate with Joe Downing. PROBLEM: Joe Downing's contact info doesn't…
-
Web forms and formulas
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 previous lines, but when the web form submission is added, it goes to a new row, not the last…
-
Timestamping comments
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 cell when someone adds content.
-
Need help making a COUNTIFS NOT formula
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 the different things that column be could be that aren't "Completed" but it seems there should be an…
-
Result look up
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 drop down list "yes" symbol indicating a sale has been completed. My question is, how can I…
-
Count children rows only if items are not marked complete
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 been marked as completed i.e. tasks that are still open? I'm trying to use this formula but I'm getting an #Invalid…
-
sorting by row ID
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. date, amount etc). after obtaining certain info based on sorting of different collumns, i…
-
Time Function
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 Smartsheets. It seems the Time Function is not supported. Does anyone know if this is coming,…
