-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
How to populate dropdown value list from another sheet
I have a list of employee information in one smartsheet. In another smartsheet, I'm recording events/things about employees. I'd like to have a dropdown list that have the list of employees names (from the other sheet) that I could use to select which employee this record pertains to. Help? Thanks!
-
Change Cell Value Automation - Can I add a formula to the cell?
I want to create an automation that when I indicate that the row "type" is "section" the workflow automatically changes the value of the QUOTE column to a formula that is =SUM(CHILDREN()) When I've tried this, the workflow adds the formula as text rather than a working function. Is this possible?
-
Who could use a PARSE function?
So I have been trying to think of how to best word it, and trying to help someone else with a solution led me down the rabbit hole I needed. How about a PARSE function. =PARSE(range, selection number, delimiter) Use case would be plentiful, but a couple of examples would be... A. You want to search a range for the second…
-
Filters and Formatting not Working
Suddenly our smartsheet has lost all filters and the conditional formatting doesn't seem to be working. It looks like nothing has changed to make this happen, but we don't know how to fix it. Any ideas?
-
Two new functions released (COUNTM & HAS)
Hi everyone, I noticed that two new functions has been released. COUNTM and HAS Here are the details. COUNTM Counts the number of elements in a multi-contact or multi-select dropdown column cell or cell range. Returns the total number of elements found. https://help.smartsheet.com/function/countm HAS Search for an exact…
-
Cross sheet references not updating
I have 10 sheets which each have multiple cross-sheet references from other sheets. For the past year these sheets have functioned as designed, and all references (Vlookup and Indexmatch) have updated automatically without me having to even look at it. However, I noticed this past week these 10 sheets stopped updating…
-
Calculating Duration - Answered
Team, It took me some time to figure out how to display duration. I have 3 columns " Date Created " " Time Completed " & " Duration " I have attached an image for refference. Formula - copy this into the first row of that column. Remember to either rename your columns or change the formula. Cheers!! =INT([Time…
-
#Invalid Ref error in a report, but not the source
I'm seeing an invalid reference error in a report on a dashboard, but the source data is good and the vlookup is pulling in the data I want to see. Any thoughts on the cause/solution? I've narrowed down, deleted and re-created the cross sheet reference several times and the error persists. Screenshots of the error and data…
-
Conditional Logic for Header fields in Forms
Hi all, With the new update to Smartsheet forms, we are able to add conditional logic to designated fields within a form. However, I noticed that while you can set logic to only populate designated fields when a certain option is selected, the headers of the fields that are NOT designated under that logic still appear on…
-
Formula in a cell that is within a range referenced by the formula
@Genevieve P & @Andrée Starå I was finally able to do some testing based on THIS THREAD and the recent discovery that you can reference a range in a formula that covers the cell that the formula itself is in. I got some interesting results when I used JOIN and JOIN/COLLECT. It treats the cell as blank, so if you just…