-
hh:mm:ss format??
I am logging time spent per job using timesheet software, and the data it exports is in hh:mm:ss format. Is this date useable in Smartsheet? From this, I want to calculate a job cost. In Excel, I would do this by using the following formula: = hh:mm:ss x hourly rate x hours in a day (24) This would give me a £ value for…
-
Automating Parent Row based off RYG Children Rows
Hello! I am looking for a formula that will show in the parent row an RYG color based on the children. If there are any Red OR Yellow in the children rows, I want the parent row to show Yellow. If there are only greens (no other color), I want the parent row to show Green. How do I do the "or" statement? Thanks for any…
-
If statement for checkboxes
Hey everyone, I have project schedules with milestones that have associated tasks for each. (i.e. releasing a drawing set includes getting it stamped, sending to subcontractors, etc). I would like to make the tasks a checklist that would populate the percent complete (instead of a harvey ball), using a formula. Has anyone…
-
Count If Formula to Count if NOT blank
I am trying to create rollup summaries in a large worksheet. For a couple of metrics I need I need to include or eclude certain things based on if a cell is blank or populated. For example - I need to count something for a processor if the Auditor fields is blank. The formula below is working =COUNTIFS(Risk:Risk, SSO4,…
-
How to track old inquires? New disscussion/attachment dont change modified date
I have a sheet where each new inquiry is recorded in new row. I created new report (based on modified column) showing inquires not modified for more than 30days, (because after 30 days we want to identify and contact inactive clients). Problem is, if I enter new discussion / attachment (usually saved through outlook app,…
-
SUM formula does not provide a total of IF statement outputs
Hi I have a timesheet tracker setup with a web form (mobile) to allow me to quickly keep track of my daily activities etc. There is a basic formula setup to auto populate my mileage based on a site code that I enter. =IF(LOC8 = "Home", "00", IF(LOC8 = "KH", "90", IF(LOC8 = "NP", "110", IF(LOC8 = "BP", "110", "xx")))) I'm…
-
Percentage Formulas and adding to SIGHTS
Hi, I am trying to use a formula based off of Counts or Sum to get a percentage of work done. Then I need to add that percentage into my SIGHTS Dashboard. I am having trouble finding an operator or formula to help me do this. Does anyone know how to best solve this issue? Thanks!
-
Counting Checkboxes of all Parent rows in a sheet
We have a sheet that has a multiple level hierarchy. One of the columns is a checkbox and I used the formula ="" + COUNTIF(CHILDREN(), 1) to count the number of checkboxes below each parent row. This created the number of checked box in the parent row. Is there then a way to count all the numbers in the parent rows (to get…
-
How to calculate the Actual Duration only when the Actual Start and Actual Finish have values?
Hi, I'm working on a Smartsheet of which two of the columns are "Actual Start" and "Actual Finish". I have a third column called "Actual Duration (days)". Both the "Actual Start" and "Actual Finish" columns are date type columns and "Actual Duration (days)" is a Text/Number type column. What I want to have happen is as…
-
SUM formula pulling 0 no matter what. Issue with using multiple formulas?
I'm attempting to have all resources check off each of the meetings they attend on a weekly basis and then pull in number of hours based off those responses. I've created a checkbox column for a meeting and then a number/text cell the right right. I wrote a formula saying, "if checked, populate with a 1.5, else keep null".…
