-
Count Help, Don't Know Where To Start
Hi Everyone, I would like to do a project status summary. Each parent is a school site, and the children are the projects that need completion. In the drop-down menus next to the projects I change the project status to complete when done. I'd like to create a list of all the school sites included in this project that shows…
-
Time to completion
I am wanting to view the amount of time it took my team members to complete a form. I know it can be done, but am having a hard time figuring out how. Any help would be appreciated.
-
would like to add an IFERROR to a simple formula, can't seem to get it to work
Hi, I have a simple formula I am using in one of my sheets to calculate a percentage: =[Training/90 day complete]@row / FDS@row I would like to amend it so that if the cell in the Training/90day complete column is blank, to leave it blank rather than calculating it and returning 0%. How would I do that? Thanks in advance!…
-
Comparing rows
Team, I am trying to compare 2 rows that are almost identical, and highlight the differences to take the most update in the same sheet. Yet I am not able to find any formulas to do so. I have tried INDEDX and MATCH but it is not giving me the results I need. Any help will be much appreciated. Thank you
-
How to over ride submitted data through forms?
Hello everyone, I have a form linked to a spreadsheet. I have callers that submit claims to our office through smartsheets using forms and the status is pending. Once their claim is resolved they call us back and we update their record to active. Is there a way for them to change the status to active when its resolved…
-
Nested if RYG
I am trying to write the easiest "if" statement and It will not work.... All I am trying to is the following: Red if the "action due date" is in the past and the "Status 2" is either Open, In Planning, In Testing, Monitoring. Yellow if he "action due date" is Today and the "Status 2" is either Open, In Planning, In…
-
Nested Or within Countifs formula
Hi, I am hoping to see if I can get help with the following formula: =COUNTIFS([Area of focus]:[Area of focus], "HGIT", Status:Status, "Complete", OR([Status:Status] = "Approved"), [Channel:Channel], <>"internal comms") Essentially, my goal is to count items that are for "HGIT" that are either complete or approved but not…
-
Item count embeded in calculation formula.
I need a formula that calculates the total cost of travel. We have a column where the traveler can identify how many quarters they need to travel, the number of trips per quarter and the number of travelers per trip, as well as the estimated cost per trip. The calculation would include (# of quarters checked X number of…
-
Using COUNTIFS with CONTAINS and OR
Hello, I'm trying to count the number of times a given option in a multi-select field appears across several columns that utilize the same list of options. I've tried is several ways without success. =COUNTIFS({Intake Data Range 11}, CONTAINS("CCAP", @cell), OR({Intake Data Range 12}, CONTAINS("CCAP", @cell))) returns…
-
Smartsheet Report Builder
When setting conditions to build reports, I have found on multiple occasions in the "What?" parameters, I have needed to specify more than three conditions that need to be treated with different boolean operators...ie. return rows that have "QA/QC" specified in auto assignment OR have "QA/QC" specified in Production Status…