-
Text added in summary/calculation
In the video by Robin Sherwood demonstrating card view he shows his template with Summary tabs visible in the swimlanes. How does he manage to present the (50 secs in) summary with "Units: 1750" I think this might be more of a string just added to the front/back of the formula in his grid view for line 2 quantity (20…
-
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…