-
SS FORMULA HELP
Hello Everyone! In need of help with a check box formula. What I am trying to do is as follows: If the row has a check box in the field, then add an icon in this box in another field And if the box is not checked then add this icon. What I have for my formula right now is: =IF(AND([Field Name@row = 1), UNICHAR(9989),…
-
Report Filters Not Responsive
I've created a helper column in my sheet for parent/child relationships, which assigns it a number based on this formula: =COUNT(ANCESTORS([SOW Item or Task]@row)) + IF(COUNT(CHILDREN([SOW Item or Task]@row)) > 0, "+", "") In my report, I've created a filter to allow for all numbers except 1+: However, the report is not…
-
Formula to return value in another cell based on several criteria
I am trying to create a formula in column 1st yr (105 hours max) that will return the value in the Vacation Balance column ONLY IF the Years of Service is <= 1 years 11 months 31 days, AND IF the Country is USA OR PRI. I am using the formula below but it is returning vacation balances whose Years of Service is greater than…
-
Matching Multiple items in Cells to single items in another sheet
I have an Intake Form that collects training information - employee name (data validated), date of specific training (forklift, OSHA 40 hours, DOT to start), and a file attachment with the sign-in sheet. I need to automate the update of another sheet with the information from the Intake Form. For ease of use, the Intake…
-
Return multiple values from one search criteria
Hi! I'm fairly new to Smartsheet formulas and have reviewed the community posts trying to find help to my question. I am trying to pull PTO requests from one sheet to another. VLOOKUP has always been a friend, but unfortunately does not pull multiple values. My lookup criteria is a single date, (ex 2/28/24) but there can…
-
Modified by column is being filled in with "automations@smartsheet.com
I need to know who last "Checked" a box in a column. After the box is checked, there are several automations that happen. Next to the box, is a column that I want to log the user who checked the box. But since there are automations, it's removing the users name and replacing with "automations@smartsheet.com". Can this be…
-
Mandatory field in Smartsheet
Hi, I have a Change Request Smartsheet, and I need to have the 'estimation completion date' collum as a mandatory to be filled by the requester. How can I implement this?
-
Display most recent comment of Child Rows in parent row.
Hello, I'm looking for assistance in creating a formula that could be applied to a whole column that would display the most recent comment of a child row in the parent row. This would help to see the most recent update to a project at a glance in reports. After the screenshot, I made another column to collect the data, but…
-
Hello,
I had a formula that was working all through the trials but then right before the roll out it stopped working! In one cell there's a column that Auto counts Responses no big deal there. In a cell in a different column =MAX([Row ID]:[Row ID]) // this counts the largest value so I can record the latest response In another…
-
Progress % based on status with cell linking
Hi I have two sheets, one acts as a master file for top level view only, the other is a more working doc. On the working doc, I have added a progress column, calculating the percentage of progress of the project based on the progress i.e. =IF([Activity Status *]@row = "Not Started", "0%", IF([Activity Status *]@row = "On…
