-
Stringing Logical Arguments
Hello, I have been struggling with this formula for a few days now and can only get bits and pieces of it to work. So I am hoping I can get some help here. Essentially I am trying to create a formula that includes 5 fields and depending on what is in them, give me three possible outcomes. The fields I have are: 1.…
-
Create percentage complete based of boxes checked
Hello, I am very new to smartsheet and still quite inept. I have a smartsheet that I am using to track a student I am mentoring. There is a coumn titled 'Completed'. This allows the student to check when a specific task is complete. I want to be able to show the percentage complete based off how many boxes are checked as…
-
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…
