-
Automate the copying of rows and deleting previous versions
I'd like to automate the copying of a row into a secondary sheet when a cell is updated. Then delete any older versions, on the secondary sheet. I have already created a system column to create project ID's. I can find previous versions of the copied data, but I'd like to automate it so that when the new information is…
-
Formula not working in Smartsheet when data is populated from form
I'm using a form to populate my Smartsheet. If N/A is selected from a dropdown list the completed column for that section should be checked (see below). I can get it to work when selected in the Smartsheet using formula =IF(([Loan Servicing]@row)="N/A",1) but not if the selection N/A is being populated from the form. Thank…
-
#NO MATCH error
Hey everyone! I seemed to have ran into an issue using a vlookup formula. When I first wrote it out it worked for that cell but when I dragged it down the whole column it no longer worked. =IF(VLOOKUP([H145 A/C #]@row, {QG Schedule Tracker Range 4}, 2) = "Not in SS", "No", "Yes") This checks if the aircraft number in that…
-
Docusign Integration - Attach final Envelope as separate docs?
We are using a Template Docusign Envelope (with multiple documents in the envelope) and sending that via Smartsheet Generate Docs Docusign Integration. When the doc envelope is complete, the document attaches as one combined PDF in Smartsheet. Anyone know if there is a way to have these attach in Smartsheet as separate…
-
Index/Match works on all rows except a couple
Hello, I have a strange issue where my INDEX/MATCH formula seems to work on all rows except, for example, this one below. This is a listing of requests for a client. I've hidden certain columns for privacy, but the hidden columns are not used at all in the formula. Every request has a unique ID (primary column). There are…
-
COUNTIFS for whole Sheet
Hey, This is probably an easy fix but I am having no luck. I want to count if anywhere on a sheet has a "4" in a cell. I also want this to separate the counts by "ITCMW", "ITCT" & "METC" My current formula is: =COUNTIFS([Pre Trip Completed]:[Doors/Gates], HAS(@cell, "4")) I need to include System:System, "ITCMW" in this…
-
Is a sheet filter with the criteria - Last Modified is in the last (days) working for anyone?
Trying to use the filter criteria with the system field "Last Modified" with criteria "is in the last (days)" value 7 but it does not work :-( Has this worked for anyone or is a bug?
-
Any templates or sample of multiple project dashboards?
Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project. Most of the reports and dashboards I've tried to create capture a single project but I'm not finding a nice way to show multi-project…
-
Nested If SmartSheet Formula For Symbols (R, G, Y)
=IF([% Complete]@row < 0.7, "Red", (IF([% Complete]@row = 1, "Green", "Yellow"))) i.e. =IF(data < number, "TRUE Symbol Text", (IF(data = number, "TRUE Symbol Text", "FALSE Symbol Text")))
-
Sheets vs Workspace
Hi all, I am just not sure how the files are going to behave after I move them to the workspace from sheets. In the attached picture I have created a sheet name rush request from customers where I've reports, dashboard, and a sheet. The sheet has a form attached to it. To share do I have to move everything to the related…