Hello, I have a form that is submitted to one of my sheets daily. Currently, new entries populate at the top of the sheet. I am using a formula that always needs to reference the top row, or newest en…
Hello, I have been defeated while trying to reference another sheet and pull information that matches multiple criteria. I need to pull an Account Number that matches both a Vendor Name and Location N…
Hello Smartsheet community, I am having a small struggle with a contact column in one of my sheets. I have a formula: =IFERROR(IF(FDO@row < TODAY(), VLOOKUP([Store Number]@row, {Setup and IT Completed…
Hi all! I am revamping a project task list template that my team uses each time we are building a new location. We'd like a high level completion status for each department involved in these projects,…
Hi all, I had a formula in place yesterday that was working fine, but this morning is returning no match. In our sheet summary, I am trying to count the number of quarantined individuals in a specific…
Hey all Hoping someone in the community may be able to help me as I have not heard back yet from Smartsheet support. I have a Dynamic View that has until now worked as expected. There is a Contact Col…
Hi all, I am wondering if accessing a report will trigger an alert from the source sheet? I have an alert set in my sheet that triggers based on a formula. If someone accesses a report that is based o…
Hey all, I have a group in SS that needs to be able to edit a report but shouldn't have edit abilities for the entire Workspace. I have set them as viewers to the Workspace and Editors for the reports…