-
Return Value if Between Dates
Hello! I have a [DATE SUBMITTED] column and need to create a reference column that returns the fiscal year that date falls in. Something like this - =IF [DATE SUBMITTED] > 10/01/17 AND [DATE SUBMITTED] < 09/30/18 RETURN "FY18" and =IF [DATE SUBMITTED] > 10/01/18 AND [DATE SUBMITTED] < 09/30/19 RETURN "FY19" I'm not sure if…
-
Sheet Summary Fields in Notifications
Is there a way to add sheet summary fields in a notification? It is possible to add cells by using {{Field}} but this doesn't work for the summary fields. Any inputs are much appreciated.
-
Linking data by Primary Column
We track data for customer accounts in a couple of different categories. This inevitably means that some customers (not all) appear in both data sets. We spend some time ensuring that the data entered is consistent across both, but this is a manual check. It'd be good to be able to 'link' data between sheets conditional on…
-
Pulling Data from another sheet
I have two sheets with a few hundred rows filled with site information. The common data between each table is the site number. What formula would I use in a cell if I wanted my primary smartsheet to check the other sheet for the site number on a row and return data from a different cell in that same row? All site…
-
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…