-
Adding the sum of a range of cells using the IF function
Hi! I wonder if someone can help me. I have a range of cells using the IF function. I'd like to calculate that range using the SUM function in another cell, but it just comes back with the total as "0". Is there a special formula that I need to use to complete this action? Thank you
-
Formula with star symbol
HI, I was trying to use a formula with symbol. Here is the formula I wrote. The formula is working but I would like it to be the symbol Starred/Not Starred and not the words. My column property is symbol. =IF(Status1 = "Done", "Starred", "Not Starred") What am I doing wrong? thanks Marie
-
Formulas
Thanks for the help!
-
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…