-
Populate a date field when checkbox checked
Hi. I need to populate a date field when checkbox checked. I tried using the following formula but the date changes each day to today's date. =IF(Checkbox@row = 1, TODAY()) This date field needs to record the day that the check box was checked keep that day for auditing purposes. Obviously I am missing 1 more step to put…
-
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…