-
syncing data between two sheets
I have two sheets which we want to use for material tracking. The one sheet is based on what comes in and is traced back to a purchase order. The second sheet is what is actually used. I would like to be able to take the actually used total and match it to the same item on the other sheet so that we know if we have over…
-
How to alert regarding a duplicate value within a row?
Hi I would like to add some sort of alert or conditional formatting, but I'm not sure how to accomplish this. For the columns impacted they are all dropdown single select columns. I want some sort of alert, could be as simple as highlighting the row, if a value in "Faculty on PTO" appears in any other column for that…
-
Error when using multiple SUMIFS in one column
Hi . I am trying to find the sum of each group of 5 rows using SUMIFS in Column 1 where the employee's name is John Smith (in cell 3 in Employee Name's column) and the status is Full-Time (in the Status column). =SUMIFS([Column1]:[Column 1], Employee Name: Employee Name, Employee Name3, Status:Status, "Full Time") The…
-
Need help with IF formula
Hello! I want to use an RGB Symbol formula that first looks at a 'Completed' cell and if "checked" returns green, but if not checked it moves on to look at a "Date" column to return RED, YELLOW, BLUE or Upcoming. Here is my current formula: =IF(OR(COMPLETED@row = 1, "Green")), IF(DATE@row < TODAY(), "Red",…
-
Background sheet not updating
I have a rather complex process I'm building out in Smartsheet, and I've run into an issue with one of my background/calculation sheets not updating and triggering my workflow. I have a sheet (FORM RESPONSES in the linked workspace) with a form attached that collects a bunch of information - one of those pieces of…
-
Can i join a Max value and a Min Value of child rows?
I have a sheet with a process listed out and stages nested under the parent stage. I want to add a formul at the parent level to show the phase range. I want to write a formula that will Join(Collect) the minimum and maximum value of the child rows. =JOIN((COLLECT(((MAX(CHILDREN()))), "-", (MIN(CHILDREN())))))
-
#DIVIDE BY ZERO Error - other resolutions not working
I am trying to resolve a #DIVIDE BY ZERO error. I've seen the other resolutions, but they are not working for me. Here is the formula that I am using: =ROUNDUP(([Anchor Install Hours]@row / {Amazon - Brownfield - Priority Sites - Set Range 2} / [# Anchor Technicians]@row), 0) I tried the IFERROR(ROUNDUP resolution and that…
-
How do I concatenate text in a different sheet and a changing number
Hi. I need to concatenate text and year that are stored in a different sheet and get the result in a second sheet so that the year number changes depending on what the year is For example : if I have the base year 2022 in Sheet 1 The concatenated texts in Sheet 2 should look like this " Calendar Year 2020" and "Calendar…
-
Adding an ISBLANK
Hi there, I have my formula that works but forgot I needed to add a clause for when a column cell is empty so it doesn't return an error, which I'm hoping will allow me to make it a column formula without too much fuss. I'm trying to use ISBLANK as that seems like the best option and I just can't see the problem but it…
-
Drop Down selections based on "master" list
Is there a way of creating a dropdown list, based on a seperate template? For example, can i create a list of colours (Blue, Green, Yellow, Red, Black" in "sheet 01" then in sheet 2 have a drop down that looks at that list of colours in sheet 01 and i can select these? Then if i add new colours to sheet 01, the dropdown…