-
Functionality Question
Hello, I am more of an Excel guy who is attempting to wrap my head around Smartsheet. I have a scenario and I am thinking it can be done, it seems like I almost find the answer but just not quite. I have records which require attention, usually in contacting users and getting require, late training complete. There are a…
-
Sheet Summary Report Grand total row ?
I am bringing in 2 separate sheets into a sheet summary report using a custom column called "Total Revenue" which is a sum of each individual sheet's revenue rows The sheet summary report is showing correctly both rows for each sheet and the corresponding totals for each sheet. e.g. Miami $138,875 Tampa $264 My question is…
-
Combining AND & OR in a formula
I have a sheet with the following three columns: --Was the question asked --Answer 1 y/n --Answer 2 y/n I want the formula to turn the flag red (cell already formatted for flags) if the question was asked, and either answer 1 or answer 2 were no (aka, i need all the no's from everyone who was asked the question). So far I…
-
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…