Formulas and Functions

Archives for March 2023

Automation email not sending
I have an automation set up that will not send for some reason. I have "Send to everyone shared to this sheet" but it doesn't seem to send unless I manually "run now".
Need a formula for the Complexity Score
I have not been succesful trying to create a formula for the Complexity Score (currently shows a total of 9). If it less than 4, it show show ""Low" right below the total, if it is 5-8, it should show "Medium", if it is 9 or greater it should show "In-Depth". Any assistance would be appreciated.
formula to change upper case to all lower case?
I'm using an email address as an identifier from a survey/form to a smartsheet. For some reason, if the email address isn't all in lowercase letters, it doesn't recognize the user as completing the form (and their form data doesn't cross). Is there anyway to automatically change upper case letters to lower case from the…
COUNT and SUM formula for Summary on Parent Rows
Hello! I am looking to fix a formula that came with one of the templates I found. The Summary section on the top I want to summarize the total contracts and total contract value...but I added parent rows to the bottom half. What should I change in the formula for it not to include the parent rows in the sum? Total…
If formulas with Parents & Children
Hello All, I have been looking for some help with a formula between parents and children. The goal is to have a column to pull a report off of so when it pulls we know it was a child and not just a regular line. The formula works for a Child but when we want the Parent line in the column to pull the parent data it shows up…
Formula to change task status to "At Risk" If due date is within 1 week
Hi, I am wondering if you can help me create a formula that will change the site status to "At Risk" if the due date is within 1 week and the status is not complete or not applicable.
Change the date to a new date in the future when met the criteria
Hi, I curretnly have a smarthsheet that consistit of giving reminders and follow-ups for some actions. I am looking for a formula that basically (IF the due date column is less and the done column is checked, then change the due date for 2 months after. Thank You
I need help creating a Formula
Hello, I need help creating a Formula. I want to pull the number of cases that has a date for a set time like 04/01/2023- 04/30/2023 The two columns are ‘’Case Number’’ and ‘’Submission Date’’.
Cross Sheet Reference Issue - Renamed Sheet Reference
Greetings, I am running into an issue with a cross-sheet reference in a Max Collect formula. Below is the intended formula: =MAX(COLLECT({Vision Media 2023 Customer Billing Tracker Range 2}, {Vision Media 2023 Customer Billing Tracker Range 1}, "Fulfillment - Physical", {Vision Media 2023 Customer Billing Tracker Range 2},…
COUNTIFS
im a trainwreck when it comes to creating formulas with more criteria is needed. I have two columns on my site tracker that I am trying to do a count if on first column is titled Status (dropdown) second column titled No hardware needed (Checkbox) i want the formula to count if the status column is "complete" and if the no…

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

Can anyone tell me what's wrong with my formula?
I'm trying to set up a project plan that has color indicators for the timeline: RED=past due, Yellow=due in the next 5 days, Green=due in the next 14 days, Blue=due later. =IF([Due Date]2 < TODAY(), "Red", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 < TODAY(+5))), "Yellow", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 <…
Help with a #UNPARSEABLE error
I want to reference the values in a column from another sheet (2025 IOE Procedure Assessments Equipment). And if any of them match any cell from the Equipment column from the sheet I'm working in then, I want the Audit on Equipment Completed column to return a "Completed" value. This is my formula. What is wrong with it?…
I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")

Formulas and Functions

Discussion List

Help Article Resources