Trending in Smartsheet Basics
-
How do I add text to a formula
My current formula below works, and returns the value, 25%. But I want to add specific text to the value returned. So it should read, 25% - Milestone 1, or Milestone 1 - 25% =INDEX({Milestone 1 - Preliminary Design Range 1}, MATCH([Activity ID]@row, {Milestone 1 - Preliminary Design Range 2}, 0)) Thanks.
-
Several Columns Have the Same Name
I have several workspaces that people use to make different sheets. The problem is that whenever I try to make a report for someone and I'm sorting out which columns to include, there are several columns with the same name. For instance, if the column name was 'Contacts', there are four columns named 'Contacts' which each…
-
Copy Row Automation
I have a workflow which when a new row is added and fulfils a set criteria, the row is copied across to one of two sheets. When it copies across, the row is filled in in its equivalent row in the primary sheet. How can I get the copied rows to fill in the next available row on the new sheet? Here is an example of the row…
