-
Multiple IF / AND / OR Statements Help, Please.
This is such a great community and a wealth of knowledge for a new Smartsheet user like me. I have done several formulas, but this one has me scratching my head. I have a [Target Date] column, [% Complete] column, and status column that I would like to automate with Red, Yellow, Green, and Gray status balls. The [%…
-
Alternative Formula to MAXIFS
Hi Smartsheet community! I am trying to find the maximum value in a range with both Vertical and Horizontal criteria. I was able to get the answer I need for a similar column using SUMIFS to add all the values together. Now I need to find the max value (however, Smartsheet doesn't have the MAXIFS formula). Could someone…
-
Copy a specific field in sheet 1 to a specific field in sheet 2
I have 2 SmartSheets - 1. My Project Plan and 2. My Communications Plan I would like to copy specific fields from one sheet to another. For example, on my Project Plan I have a "Start Date" on row 177 that I would like to copy to "Admin Date" on row 1 of my Communication Plan. The Project Plan dates change periodically and…
-
I have a formula that tallies Net Work Days between "today" and a deadline.
I have a formula that tallies Net Work Days between "today" and a deadline =NETWORKDAYS(TODAY(), Deadline@row) However, if this deadline is in the past, I'm hoping that the formula will display an "N/A" as the result of the formula. Thoughts?
-
Mround and Round functions
Hi, What is the difference between the MROUND and ROUND functions? Also, I'm facing an issue with the rounding function in Smartsheet, where the result seems to be different from Excel. How can I ensure that the rounding function in Smartsheet gives the same result as in Excel?
-
Count and then Rank multiple text values in same Cell in one Column
I have been scouring the community page looking for help with this question and plan to set up a Pro Desk appointment, but they don't have any availability until next week so any help is appreciated. I have a form collecting data into a sheet and then a separate calculations sheet. I am trying to 'count' within a column…
-
Using Vlookup where search value contains multiple values (column is a drop down)
I have a main sheet where i want to select "Plants for Consideration", then after selecting a production plant the emails of the people involved will populate in another cell. I've created a separate smartsheet to reference which has the column on the far left "Plants for Consideration" and then in another column (column…
-
Formula for countifs and or from multiple columns
Hello, I am trying to count if {Goal #1} and {Goal #2} are not blank IF {Office Name} is [Primary Column]@row OR {Division Name] is [Primary Column]@row. The way my tracker sheet is set up is that I have Office Name & Division Name as separate columns and I need to count that each office or division has completed Goal #1…
-
Parent & Child Formulas in the Same Column?
My sheet is structured as a sort of tiered task checklist. There are several Parent rows with varying numbers of Child rows. There are two columns that are involved with my issue: the first is a "Status" column, and the second is a sort of "True/False" binary check labelled as "% Complete." There are no formulas in the…
-
Trying to find specific headcount for each month of arrivals and how to include End Date
Hello All, I have a formula currently counting the arrivals for a headcount but it is not counting who is staying past that month. How can I change my formula to accomodate not only new arrivals but also the current personnel that are there for future months. I.E. New arrivals + Current personnel =COUNTIFS({TA Management…
