Hi all, I am trying to autopopulate two fields into my form from two existing columns with data. I've been following the community and so far I am able to pull one field using this formula: ="Linktoth…
Hi there helpful people! I am using smartsheet to track jobs in order to then export a monthly report. I have approx 2000 postal/zip codes attributed to client sites within a particular State - and wh…
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Complet…
I tried to create an auto clear function for a specific column using automation. It's should clear the column of its content at the start of every workday, however it does not appear to be working. Do…
Hi there, I'm looking to see if there an application that can handle a little more robust automation of sharing between sheets. I'm looking to create one form that can populate and update several diff…
Hello, I have successfully established a formula link between two date columns (Start & Finish) and my 3 status trackers (Completed, In Progress, Not Started). The formula I have used successfully is:…
Simply, I need to reference another sheet and get all column values on the LAST row!!! I thought this should be simple to do by indexing another sheet, then capturing the last row and include all colu…
