-
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…
-
How many rows can a report collect?
I created a report that pulls data from 4 different sheets. It has multiple items on a single date, so calendar view is the only view I am interested in using. The data on the sheets goes up to May, but in the report, it stops showing at April 15. When I look at the report in Grid mode, it is exactly 500 rows. How can I…
-
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?
-
How do I track incoming emails in a Smartsheet?
We are getting slammed with inquiries to our info@ gmail address. I think there's a way to send all those emails to a Smartsheet so I can assign, triage, and track our responses.
-
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…