-
Workday formula doesn't calculate correctly when value is "0"
Hello All, Having difficulty getting my formula to work properly when a column's value is "0". If the value is >0 it works fine. The formula is supposed to follow the WORKDAY variable and exclude weekends, which it does unless the value in the [Days to add] column is 0 at which point it seems to ignore the workday rule.…
-
Create a formula to calculate the price of comma delimited items in 1 column.
I have a vendor registration form that connects to Smartsheet from Google Forms using the Smartsheet Add on for Google Forms. When completing the registration form, the vendors can select up to 4 tables to rent and each table may have a different price. The form automatically created and populates my Smartsheet with the…
-
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…
-
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…
-
Sheet Column for Missing Attachment
Hello, I'm pretty new to creating functions for columns and wanted to see if there is a way to have a Missing Attachment column displaying Yes or No depending on the attachments themselves for the row? It seems like the attachment "paperclip" itself can't be leveraged as a filter in the Work Insights graphs. Thanks! Jim
-
Index Match with multiple sheet references Help.
I am trying to use the index/match function across multiple reference sheets. (Formula #1 works but just across on reference sheet) =INDEX({Team X Email list}, MATCH([Five9 ID]@row, {Team X Five9 Username}, 0)) (Formula #2 does not work across multiple reference sheets) =INDEX({Team X Email list}, MATCH([Five9 ID]@row,…
-
How to Divide Across Sheets?
I am trying to take a value from the same column & row on a separate sheet and divide it by 160. I tried to go super simple and just do ={Sheet reference}/160 and got invalid. Any ideas on the best way to do this?
-
Help with formula in calculating time of service
I am working on a column formula (Years of Service) to calculate the years, months and days as of TODAY from the employees’ benefits service date see formula below I am using. =YEAR(TODAY()) - YEAR([Benefits Svc Date]@row) - IF(DATE(YEAR([Benefits Svc Date]@row), MONTH(TODAY()), DAY(TODAY())) < [Benefits Svc Date]@row, 1,…
