Formulas
Discussion List
- I have a due date (e.g. 28/10/2027) and id like to be notified 2 years before the date. As smartsheet only allows me to set an automation 365 before a due date, I made a helper column which would brin…
- I am attempting to calculate the average number of working days it takes to complete a request, Criteria I want to base the data collection on include: urgency level Month and Year(I created a rolling…
- I need help taking this string of text and creating column for each unique number sequence that is separated by comma. I was able to do the first column, but I'm unable to figure out the rest. Any hel…
- through use of a form i have a sheet that will create rows with certain departments and issues they've encountered. i have a master sheet that i want to populate with the most recent issue encountered…
- I want to have conditional formatting comparing 2 dates: Where [Actual] > [Due Date], column will be red Where [Actual] < = [Due Date], column will be green Where [Due Date] has a value but [Actual] i…
- For new hire training there are several items they must complete for training requirements to be met. I am trying to figure out a way to show % uncomplete for all open training items (boxes in red tha…
- Hi, I am trying to create a formula with dates that will change each month to the start and end date of the new month, so I was hoping that I could link the start and end dates to a cell in the Smarts…
- Hi, I'm hoping to make the RankEQ formula have a criteria component to the ranking to rank overtime on deck per shift instead of by the whole group. We keep all the information on a larger spreadsheet…
- Hello Everyone, Wondering if anyone has created a sheet that pulls stock market data (share price, market cap, etc.) directly from the internet. Thanks for your help. Shawn
- I am using VLOOKUP in a sheet (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VL…