Formulas and Functions

Archives for September 2023

"Project Requirements Matrix" excel Template
I am trying to import a excel template into Smartsheet but when I do the formulas are all out of sync. The template was on the Smartsheet website but whenever I click on the "Click here to Create in Smartsheet" it asks me to sign up for an account. Manually uploading it just makes it very cumbersome due to the formulas…
Auto populate formula column not showing up on report
Hello! I have a sheet with a formula to auto populate a checkbox is a status is entered. The checkbox formula works on the sheet, but when I created a report to pull the checkbox column, the column is empty and will not show the checkbox. Did I do something wrong? Is there a way to populate the column in the report and…
Conditional autonumber filled in cell
Is it possible to have several autonumber cells in the same row shich are automatically filled in when another checkbox in the same row is checked? I need up to 6.
Formula
I am building on my Dashboard, and I am using the Countifs formula to input data into my metric sheet. I now have certain parts of the document that has multiple options that I would like displayed. Is that possible?
How can I label rows based on their level 0 text?
I'm looking for a column formula that will apply the text from level 0 to all of its children, grandchildren, etc. My sheet has multiple level 0 rows.
how can I copy content of 1 column in report into a different sheet
Hi All! I am looking for a solution that will automatically copy the content of one column into a column in a different sheet. Is there a way to connect a report to a sheet in a way that will allow Smartsheet to automatically copy the data in one report column to column in a sheet? To give a little background: I have a…
Alert when 3 travellers on same flight number
I have a very simple form which records booking reference (text), flight number (text) and date (date) and Alert (free text) I want an alert if a third traveller is booked on the same flight and date.
Need to set up a workflow based on tickets
I am trying to set up a workflow to send an email when the criteria on a smartsheet has been fully completed. Example: Customers name is Nikki Ono and all 5 of her items are completed. The items are listed on separated rows with separate ticket numbers and each have a "ticket # of" (1 of 5, 2 of 5, 3 of 5, etc.). Once all…
If/Then formula
I need to perform a calculation from 3 columns if criteria in a third column is met. What is the formula? Any help is appreciated!
Is there a way to change the color of an entire row when any text is in a cell?
Hi! I'm using Smartsheet to track some meetings for a calendar that I manage. I'm wondering if there's a conditional formatting that I can use that if any text is in a cell e.g. "holds for 10/1, 10/31, 11/6" is there a way that such text would enable the entire row to change color? Or does it have to be a single formatted…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How do I get a column that shows the automated % complete for each activity?
I am struggling to get any formulas to work, I need a column that shows the percentage complete from the start date to the finish date - shouldn't be that hard but this is causing me so much grief. Every formula I find doesn't seem to work and I am not savvy enough to know how to update the formula so that it can work.…
Looking for assistance with a formula
Hi all, I am new to formulas and functions in Smartsheet and have a large sheet that I would like to summarize using an "average" formula/function. I need to include at least 2 separate criteria to filter correctly and I am having trouble combining the avg and collect functions as suggested in the functions list. I have…
Can you match a date from a drop down column?
Hi, I was trying to focus on preventing errors by added a list of very specific dates one can submit requests. I was hoping to have a drop down of dates to choose from. Then I have additional columns that will match that date selected and autofill the rest of the due dates from another sheet. If the user inputs the date…

Formulas and Functions

Discussion List

Help Article Resources