-
Newbie - Tracking Item location based on most current date
I am fairly new to Smartsheet's and am struggling to figure out some of the formulas. I am with a volunteer fire department and we are using Smartsheet's to track our equipment and maintenance. I currently have a sheet that tracks when we fill our air cylinders and which station the cylinders are at. Each cylinder which…
-
Automation - Trigger a notification after status has been updated
Hola, Need some help with an automation. I have notifications triggered based on status (Open, Manager Approval, Closed). There is a step that I need to trigger a notification when a status moves from Manager Approval to Open, can this be done? I have a separate notification for when the status is first set to Open. Thank…
-
Need a formula to output the quarter that a project starts in
Hello...I have a Master Project Sheet that houses all of my projects. I want to create a column that will look at the start date of the project and determine which quarter of the fiscal year it starts in. So it will output Qtr 1, Qtr 2, Qtr 3, or Qtr 4. Can someone help me with this? Btw, my dates are not hard entered.…
-
Automation Condition
I have a form that captures user feedback and sends a summary every Friday for the previous 7 days. I would like to add a condition that if no new feedback was submitted the summary indicates "No new responses were submitted this week"
-
How can I change the priority automatically based on a due date
Hi all, I have multiple rows of materials that need to be released before the due date, I have categorized them in Critical priority, Priority 1, 2, and Regular. Is there a way that smartsheet will automatically change the priority based on the due date entered if my team has not yet addressed the row?
-
checkbox formula for last 30 days
Hi, I have a date column which lists down all the dates in the year and a checkbox formula. In the checkbox column, I would like to insert a formula that would perform the following function for me: If the date in the date column (row@cell) is in the last 30 days then checkbox.
-
Summary Report IF Function
Trying to create a summary that uses the following logic: IF Type=Project AND Stage=Construction THEN SUM Homes-CUR amounts
-
Combining 2 IF statements
I have 2 valid IF statements but I would like to combine them so the value from either statement is returned in one cell. Below are the 2 statements =IF([New Priority]@row >= 14, "Level 1", IF([New Priority]@row <= 9, "Level 3") =IF(AND([New Priority]@row >= 10, [New Priority]@row <= 13), "Level 2")
-
Help with IF/ OR formula
I'm trying to combine the two formulas to get: If a then b or If c then d, else null. The individual formulas work but I have a challenge combining them.
-
VLOOKUP - want empty lookup result to allow free form typing
Hello, I'm using this formula: =VLOOKUP([Location Search]1, {Locations Range 1}, 2, false) where [Location Search] refers to a "LOCATION SEARCH" column in the sheet collecting the data and {Locations Range 1} refers to my look-up table below. It returns the "LOCATION RESULT" column below and I need it to be exact...thus…