-
Adding subsequent row ID numbers to prefix if cell is not blank
Hi all, I'm struggling to create a row ID field where it will populate an ID number ID_RC_1 and so on if the Employee Name cell is not blank. If it's blank then it will populate "-". Is there a way to create sequential numbering to be included after the "ID_RC" prefix? Looking for : ID_RC_1, ID_RC_2... is name cell is not…
-
Conditional Formatting
Hi, I have a formula in a customer field that identifies if a task is on schedule or behind, but I want to use a RYG circle that automatically updates based on the disposition of the formula. For example, if the task is shown as behind schedule, then I want the circle to be red. Is that possible?
-
Planned to Actual RYG
Seeking help on a formula to show RYG. I was getting an unparseable error, however most recently receiving errors regarding syntax. I want show the following: If % complete is 100%, Green If today is greater than finish date AND % complete < 1, Red If % complete is < 50%, Yellow else Green I have looked at this until I'm…
-
Metrics for Dashboard with Charts for Current User
Is there are way to identify if the contact listed in a cell is CURRENTUSER()? I would like to create a sheet with multiple metrics so that the charts displayed on the dashboard based on these so data for the logged in user. I understand that for reports filter can be used but unfortunately reports are not supported to be…
-
Check a box when a list of names containing duplicate names contains the first occurance of a name
I am looking for a checkbox formula or another callout that will look at a list of project names and return a flag or check or another identification of the first occurance of each project name in the list. I am trying to get an accurate count of the number of jobs in that list. The list is small at this point, only 2…
-
Summing a column if a date falls within a quarter.
Hello, Could someone help me with a formula that states the following: sum the square footage if Construction Start date is within the Quarter and the Status is one of these: Complete, Construction, Executed LOI, Priority. I'm thinking I may have to add 2 hidden date columns to clarify the different quarters. Formula page:…
-
Help! Multiselect Column Formula with INDEX, MATCH and HAS
Hello Smartsheet World! I am attempting to run a formula that will return contact emails depending on which departments are selected in a multi-select dropdown column. Sheet 1: Improvement Notes Smartsheet -Dept Attention column is a multi-select dropdown -Department Contacts column (in green) is a contact list that allows…
-
Workday formula
I have a workday formula in place now which calculates an expected due date from the date of submission. I've checked the results and find that the calculations are off by 10 days. The expected date should be a combination of two SLAs. The first calculating the due date from the submitted date using a department SLA of 2…
-
Unique IDs for Unique Values
I'm trying to assign a unique id (sequential number) for unique values within a sheet. I've been playing around with INDEX and MATCH, but am having a hard time getting something to work. Any ideas on how to get a formula to have row "ID" list the way I need it to? It needs to assign the ID value if Tract No. already…
-
Created By Problem
I'm trying to create a column that shows the person who entered data on the line using "Created By." However, when I do, the email that shows up is the owner of the sheet, all the way down the column. I can't seem to get rid of it, even when I delete and re-add it. Does anyone have an idea on how to make it so the person…
