Formulas and Functions

Archives for August 2023

How to get automatically an average data based on date rage on a daily basis
We are using form to create performane data per robot per run ( input can be few times a day) I need to start measuring daily avereage for their performance seperately (1 called North 1 called South) but can't figure out formula for it and then I'm assuming creating a chart would be straightforward? but not done it before…
is there a way to show total values in forms sheet?
A department within our organization needs to see total values for items filled out in forms. Is there a way to see an accumulation of values as the managers complete certain questions in forms? For example, within each of these items are four options, and each option is worth a certain value. The managers need to be able…
Finding the earliest date for each vendor
I have a list of contracts that need to be audited periodically. I want to put a column into the list that will show the earliest date required to do the audit based on the vendor and contract expiration dates. In other words, if Vendor A has 10 contracts with expiration dates over the next 5 years, what is the earliest…
Show all Children Health Ball Colors in Parent Cell?
Here's an example, if there are 3 children with different health statuses (see ss below). Is there any way to show all three colors in the parent field? Thanks!
Conditional formula
Hello! I'm trying to write a formula where the I account for back filled data and then data with a timestamped "Created" column date. How can I combine the following two formulas? The one for current data: =IF([Backfilled Data]@row = 0, IF(MONTH([Date Submitted]@row) = 1, " (01) January", IF(MONTH([Date Submitted]@row) =…
If Column is Greater than 0 Change Health Bubble to Red
Can someone please help me with this formula. Everything is working, other than the last section of the formula (IF([B/O Quantity]@row (greater than) 0, "Red") Sorry, it won't let me put the greater than symbol in the text box. I want when the "Health" column to turn red whenever the "B/O Quantity" is greater than 0 OR…
Convert date field to month text
Hello! My goal: 01/02/2024 returns a value of January or January 2024 in another cell The column that contains 01/02/2024 is a formula calculating this date. I need to show the month (and year if possible) in text in another column. Is this even possible?
I need help Join/Collecting Rows
So I have an issue with Smartsheet formulas where I am unable to write the formula to join rows. So, if the "left_company" Column values are equal, then join/append the "Timeline Date" values so that the output is showed on the "Timeline" Column. Do not populate the "Timeline" Column if there is already one for the same…
Dropdown status record a date
Hi - I have a project tracking sheet where the status will be updated numerous times over the life of a project (from a dropdown selection). Is there a way for the date of each status change to be autocaptured somehow? Where would that info show up? Is there a report that could be run to tell us each of those dates?
Update a date filed with another date automatically
Is there a way to update a date field automatically if a date is put in another filed? Currently we have an event date in the column, but I would like it to update if someone requests an alternate date. Is that possible?

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

Auto number
I'd like a document numbering intake form that assigns an auto number based on a series of selections. How best to do that within the form/auto column?
How to sort by the summary count in my row report from Highest to Lowest?
SUMIFS when date cell ISBLANK
I'm trying to add "if date cell is blank" criteria to my SUMIFS formula, but get "INCORRECT ARGUMENT SET" =SUMIFS({EBOM - 4" CONDUIT QTY}, {EBOM - 4" JOINT TYPE}, "GSK", (ISBLANK({EBOM - ACTUAL PROD DATE}))) What am I doing wrong?

Formulas and Functions

Discussion List

Help Article Resources