-
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…
-
Isolate User Entered Value in Multi select list
I have a multi-select list that looks like the below. My goal is to map form results to a PDF and I've used helper columns to turn the responses into checkboxes [formula for those: =HAS([Indicate the type of referral source]@row, "Yes, parent")]. However….I do not have the multi-select limited to my answers so that staff…
-
Cross reference sheet average number of days between two columns/dates while excluding blank values
Hello, So to be able to do this so far I have added a helper column to my main smartsheet. This column I called "Days Between" just counts the amount of days between column Referral Faxed Date and Eval Date. Helper column code: =([EVAL DATE]@row - [REFERRAL FAXED DATE]@row ) This seems to be working fine but we don't…
-
How to replace a contact name using a formula
I have a Control Center program that creates a project management sheet for each new project. In the Intake Sheet we have a contact column "Project Manager" where Control Center pre-populates the project manager's contact name in every row, of the project, where the project manager oversees the task associated with that…
-
How would I add in a month based off a date in another column
Hi, I am needing to create a column that will display the correct month based off a date in another column. My columns are below. I am not certain on which formula to use. Thanks for the assistance!
-
Formula to find data in table with multiple columns based on 2 critera
I am looking for a formula that will look at this table and pull the hours per week based on 2 criteria – group and week. Right now, I have the tables separated so that I can use a vlookup formula. But that means I have to have 5 different formulas, 1 for each group. =IFERROR(VLOOKUP(ROUND(($[First Receive]@row - $[Week 1…
-
Index/Match suddenly not working
Before I go down a rat hole, has anyone else noticed that an index/match suddenly not working? I have a sheet that's been working for a couple of years and as of this morning suddenly is showing NO MATCH where it was working yesterday. Thanks. /mrc
-
How to Display Proof Images on a Dashboard
I am looking for a solution to create a workflow that automatically displays the most recent Proof version as an image on a dashboard. I have created both a report and a sheet that mines only the rows that have proofs into a stand-alone sheet/report but are not able to find a way to have Smartsheet pull the proof image to…
-
Multi-part calculation
Hello. I have an "intake" sheet in which I now have a calculation sheet in order to start putting numbers on a dashboard. What I'm trying to do: Set up a formula where Smartsheet will (for example) sum the Units sold only if the Year is 2026, month is 1 and City is New York. Smartsheet has been hitting me with a "0" when I…
-
Sheet Reference Limits
I am building a summary sheet that needs to pull data from 60 different sheets as reference, but it keeps saying that I have hit my limit on reference sheets? I would use the report but I can't seem to get the report to pull the information in the same way. I have 64 sheets and each has at least 3 different projects. My…
-
If Formula to return highest priority
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…