I am attempting to build a template where I only need to change one field, based on that field value, in my worksheet that will update multiple formulas in the worksheet. Is it possible to reference a…
Hi I have a sheet that tracks time spent on multiple sites, I'm trying to add this to a metric sheet but struggling to get the metric sheet to add the total time spent against each site as a total. Ca…
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 week…
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 tabl…
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 Coun…
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 …
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…
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 …
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…
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 User…