-
VLOOKUP separate sheets
I would like reference sheet A zip code with zip codes in Sheet B, and when there is a match change a specific column status in sheet B sheet B status
-
Autopopulate Fields from existing columns into a Form
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: ="Linktotheform............?NameandSurname=" + SUBSTITUTE(NameandSurname@row, " ", "%20") Like that it works perfectly and I am able…
-
Change a cell value If a certain Postal/Zip Code is entered, is it possible?
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 what I'm hoping to do is set up an automation (either within a workflow or a formula) where if a particular postal/zip code is…
-
ADD LAST COMPLETE DATE
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 Completion Date will register the date of last column that changed to "complete" status. I really appreciate any help! Rob
-
Time Based Automation
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. Does Smartsheet need to be open for automations to work? Any information is much appreciated. Thank you!
-
third party application recommendation for robust sharing automation between sheets
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 different sheets. do I need a third party app for this? Thanks! Deanna
-
Nesting ISBLANK within IF(AND) Statements
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: =IF(AND(Start@row > TODAY(), Finish@row > TODAY()), "Not Started", IF(AND(Start@row < TODAY(), Finish@row > TODAY()), "In…
-
Log of Alerts
How do I find a log of the alerts that have been sent? I am trying to determine if an automation that I set up is working.
-
Simply Retrieving Last Row Referenced in Another Sheet
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 column values in this last row??? See Example: =INDEX({EXTERNAL SMARTSHEET Range 20}, LAST ROW, ALL COLUMNS) What am I doing…