-
What Does This Formula Do?
Does anyone know what the below formula does? =[Project Manager]# This is set as a column formula in the "Project Manager" column and I believe it is filling in the assigned Project Manager contact, but I cannot figure out how it works. It is used to send alerts to the PM, and I need to duplicate the functionality for an…
-
How to calculating the age of a cell in hours
Background - I have a Form, which outputs as a row in a Grid, an extract of which is as follows - The 'Date Raised' column contains a System-generated - Create (Date) value, and the 'Current Date/Time' column contains today's date (using the =TODAY() function). Problem - I am trying to find a formula-driven solution, which…
-
Creating a technology device loaning process
Good day everyone. I am new to the community but not new to Smartsheet. Have been using at my company for a number of years now. My team has acquired a quite a few pieces of equipment and it seems that we are constantly loaning them out to other teams for certain periods of time. I have been working on a loaning process…
-
Automated Formula Question
I have two Smartsheets: Config and Labeling. Both Smartsheets have Document #'s in them. The Config Smartsheet has multiple Document #'s in each row, in different columns, while the Labeling Smartsheet has one Document # in each row, all in one column. Both Smartsheets also have a Status column with the same dropdown…
-
If cell is blank put N/A
I have created the below formula to check the contents of a cell and lump it together neatly. However, if the cell is blank, I would like it to return a result of N/A. How do I go about that? Not all cell's will have data and I don't want the summary to be confusing if it's just left blank. ="ABC:" + ABC@row + CHAR(10) +…
-
Count if on two columns
I have a sheet that pulls from another, I need to do a count if for two different columns. I use this formula for one, how do I add another? =COUNTIF({Date 2}, [Start Date]@row) I need something like: =COUNTIF({Date 2}, [Start Date]@row), =COUNTIF({Review Board}, [ReviewBoard]@row=XX) It is an agenda sheet that has a set…
-
Removing Rows at Bottom of Sheet - Affecting Formulas on Dashboard
There are about 10 blank rows at the bottom of my sheet that keep coming back, even after I delete them. I either need to know how to permanently delete them or how to adjust my formulas to not include them because they are affecting our dashboard results. Any help or advice anyone has is welcome. Thank you!
-
How to get top 5 most caused services from countifs roll-up by month
I work for a bath remodeling company and we want to track the top 5 reasons we have services from our service calendar in Smartsheet. I created a COUNTIFS roll-up formula that is below and located in the children rows below Top # 1 Service from pic: =COUNTIFS({Nature}, $Label@row, {Month}, INDEX(ANCESTORS(), 1), {year},…
-
If AND or OR formula
Hi Experts, I would like to extend my formula in column Tech Pack confirmed on time. It works well with the color balls. =IF([Dev sample needed?]@row = "", "not needed", IF(AND([CAD upload on time ?]@row = "Green", [Pattern confirmed on time?]@row = "Green", [Tooling confirmed on time?]@row = "Green", [Materials confirmed…
-
Checklist workflow automation
I'm trying to convert a onboarding checklist into an automated workflow. For example. Role X has tasks 1, 2, 3 associated with it. Role Y has tasks 1,2, 6,7 associated with it. I would like the tasks to auto-populate based on the role. It would also be great if I can notify people when it's time for them to work on their…