-
Condition code to include dates in serial order
Hello mates , I want to make automation that take effect on condition if dates reached after 2 days to 20 days I listed all dates seperating them with comma (,) . is there a short code or formula to include all these days ( weeks or months as well ). I tried 2:20 and 2-20 and it did not work 😔 Thank you, in advance for…
-
Can I pull data from different columns and deposit them each into a specific cell?
Hello! I'm creating a report for students who check in for class from a form. The sign-in sheet is the same for all of the classes, so it would have several different dates and classes on it for the whole school year. It has a single-select dropdown column for them to select the class, and a "Full Name" column that has a…
-
Possible bug: Smartsheet adds a trailing space to random cells
I've encountered some strange behavior where Smartsheet automatically adds a trailing space to a cell. Below are two columns. The right column adds a "|" to the value in the left column. You can see that in the penultimate row a trailing space is added to the cell: I am using the COLLECT function to show the contents of a…
-
What would be the best way to turn a YEARDAY value into a regular date?
Hello, In my company, we have a date code we put on our products. This date code consists of a Julian Date (3 digit YEARDAY value), the 2 digit year and then the machine it was produced on. We are reporting this date code into a sheet and I am wondering the best way to convert it. I have thought about using an if statement…
-
Returning the Last Value that Meets a Certain Criteria
Hello, I will try to explain this the best I can. I have a column that has an employee's name in it, and another column that stores a value of points that they obtained for a certain day. My issue I am having right now, is that I have their total points keep adding when their name is on the row. If their name isn't in that…
-
Countifs formula looks at two columns, multi items in one of the columns
Hi, Always appreciate your time. I feel like this shouldn't be hard - end of day eyes maybe? Column #1 count if a particular Stakeholder name Column#2 count if Status = "Open" or "Ongoing" I'm getting errors with these formulas =COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, "open",…
-
Multiple nesting help!
So I have 6 survey questions with response options of "below expectations, meets expectations, and exceeds expectations." I need it to tell me how many below expectations for question 1 are in each region and so forth for each response option and region. So far this formula works great! =COUNTIFS([Delivery…
-
How to select result from table of data?
This is a weird one that I couldn't find any help on. I have two sheets. On the first one is a bunch of data and formulas, but the end result is a column with the number of miles each person has walked. The second sheet has a list of cities, along with their miles between each one and a cumulative number of miles for the…
-
Combined IF AND formula with range
Good afternoon, I am trying to return values in a cell based on data in another cell as it falls between a range Here is the range: 1 Star 299 - 966 2 Star 967 - 1160 3 Star 1161 - 1330 4 Star 1331 - 1509 5 Star 1510 - 2300 I've gotten through 1 Star and 2 Star but am receiving an error when I try to tack on the next range…
-
Pull Most Recent Invoice Data for An Account Using INDEX/MATCH/VLOOKUP/MAX (Or Other)
Greetings! Our team uses a Smartsheet to track monthly invoices for each client. Each invoice date is listed separately for each client (see attached). We are interested in populating in another Smartsheet the date of the last invoice. For some clients, it might be 02/28/2022, for others 12/31/2021, or other dates for…