-
Nested IF Formula for Automating Related Columns
I have a sheet that has rows added through an automated background process (not a form). As the rows come in, they are assigned a date in a column called "Date of Inquiry." There are two other pertinent columns in the sheet: a Harvey Ball column called "Status" and a dropdown-menu column called "Outcome." The Harvey Balls…
-
Need help with creating aging buckets.
Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over? =LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",">30",">45",">90",">180"}) I am entering this formula in the column "Equipment Date Range" and validating the data on column "Days…
-
Use a form to trigger a new project
I'm trying to automate the onboarding process for new hires. Here's what I want to accomplish: We hire a new employee, the manager fills out a Smartsheet form and based on that form it starts an Onboarding Project sheet that is a template. Can I do that? If so, how?
-
Using Join with Logic
Is there a way in Smartsheet to combine the data in the rows below AND include the Column Headers AND exclude the "No Impact" Status? The end result should look something like this:
-
COUNTIF HELP W/BLANK CELLS
I am trying to count the number of employees that have access to work remotely and have not been furloughed or laid off. The columns I'm looking at are: MODIFIED STATUS & TELECOMMUTER. The values in Modified Status are: Furlough, Separated, Reduced Salary, Reduced Hours & Other. The values in Telecommuter are Permanent &…
-
Index/Match? Not sure best function for my needs
Hello, I have a very extensive sales tracker that I use to log charges and calculate the sales rep's commissions based on those charges. The commission percentages change depending on a variety of scenarios, so I created four columns with separate formulas for each scenario. I need the commission column to auto-populate…
-
IF and HAS and OR formula combined (or alternative)
Formula wizards! Can you help me with this one? I have a column for Primary Team (single select) and a column for Secondary Teams (multi-select). I want to drive a report widget to include rows where a certain team, let's say "Team X", is either primary or secondary. Report parameters won't let me do this (because I also…
-
Formula for COUNTIF
We have a form for tracking sick time. Employee must fill out the form on first day of sick. They have to fill out the same form again when they return to work. These are both tracked in the Status column (Sick and Returning). We also have another column titled quarantined and the drop down options are yes and no. This…
-
Formula using <>
I'm trying to create a formula that will return a red, yellow, or green ball. I saw the below formula on someone else's comment a while back, but wasn't able to find it today. Right now my formula is: =IF([Late Tasks]@row > 0.75 * [Total Tasks]@row, "Red", IF([Late Tasks]@row <> 0.5, "Yellow", "Green")) Can someone tell me…
-
"Save As New" Not Preserving Cross-References
Hello, I'm building a sheet in which I'm using lots of cross-references in the sheet summary. I plan to use it as an active metric field to display summary information from data in other sheets. I will need to copy the sheet about 30 times. I want to do this without breaking the cross-reference since it would be VERY time…