-
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…
-
Summation of costs
Hi all, Disclaimer: SS newbie/teaching myself. I have Control Center provisioning a set of artifacts once a project is approved. Specifically a cost tracking sheet that I'm trying to roll into a Portfolio Summary, and I've hit a wall. I'm trying to roll up all actual costs into the Portfolio Summary in the Actual column.…
-
Auto Add a Date
Hi, I have a Smartsheet with a Check Box for all clients that started services as well a a date column for which date they started. I would like to create a formula where a a date Auto populates, but the date should be 30 days later then the original date of when services where started if the checkbox is checked. As of…
-
Overall Average Percent Compete
Hi All, I have looked around on multiple forms and haven't been able to find a solution for why my formula isn't working.I am trying to determine the formula for the total project % complete of the children rows. For the Project Initiation rows I have the formula =ROUND(IF(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()) > 0,…
-
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…