-
How do I copy a formula and update a cell reference
I'm an excel user, but new to Smartsheet so I'm still trying to figure out how it works. Please see screenshot attached for reference - I have a formula in the "Yes_2" cell (circled in red). That formula references another sheet "CSF Questionnaire Range 7" (highlighted yellow). Next, I copied the formula and pasted it in…
-
Check Box To Pin My Location
Good afternoon, We have a "Shipping Complete" column with a check box and a "Pin My Location" to GPS the location. Is there a formula that would pin our location in the "Pin My Location " column IF the "Shipping Complete" checkbox is checked? Thank you
-
SumIf and Contains referencing another sheet
Hi All, I have a sheet with a column of project codes and rows of individual's hours for each project. I want to build summary information on another sheet. So I want Smartsheet to sum the number of hours where the project code contains a unique set of 4 characters. I've gone through several of the community questions but…
-
COUNTIF AVERAGEIF
Hi, I’m trying to create a formula, that includes all that the Column Status contains “Current” & Column Rep. Name contains “Mike Bass” average on Column “Total Spent” I tried the below but didn’t work. =COUNTIF(Status:Status, ="Current", (AVERAGEIF([Rep. Name]:[Rep. Name], ="Mike Bass", [Total Spent]:[Total Spent]))) Pls…
-
Suppress a dashboard widget if the underlying report has no rows
I have built a status report dashboard and would like to suppress a widget if the underlying report has no rows. For example: I have a report for issues where the PM needs help from someone (Help Needed checkbox). If there are no rows checked for the current reporting period, I'd like the report widget not to show up on…
-
I need help with a count formula
Hi All, I need help with a Count formula. I columns that have a 3 option dropdown and I want to report on the number for each using a formula (Countif /s or any other formula). I am happy to setup 3 separate formulas for each of the 3 options, so don't need anything fancy. Just need help creating a formula that counts the…
-
IF, OR, Populate Statement
Hello everyone, not sure if this one is possible, but I'll give it a go. I want to create one formula that basically functions as below: IF([3MO Left Target Amputation]@row="Yes", Insert Date from [3MO Maj Amputation Left Date]@row),IF([3MO Right Target Amputation]@row="Yes", Insert Date from [3MO Maj Amputation Right…
-
Self-updating report based on sheets in folder
Hi there, Is there a way that I can build a report so that when a new sheet is added to a smartsheet folder, the contents of the sheet then automatically gets compiled into a report? I saw that it was possible to select a folder when building a report, which I was really hoping would have that functionality. But it looks…
-
Moving a group of rows to complete sheet
Hi! I am creating a month end checklist for our Accounts Payable dept. My idea is that all rows are visible even if checked off until the final Month End Close Complete is checked. After this, Row 1-55 would be moved to a completed sheet and a new month would start the exact same way. I cannot figure out how to move a…
-
IF statement returns formula statement, not value of formula
I want the value if true, value if false in my IF statement to return the results of 2 different formulas. But if returning the language of the formula itself on the value of the formula. I need this cell to show how long a position has been open, and if there is a position fill date, how long it was open before being…
