-
If Then Formula for 2 Columns
Hello everyone, I'm still a "new" Smartsheet user even though I've been using it for over a year. I want to set up the following formula: if column A equals 1 then column B equals 2. I want to apply the formula to both columns. For more specific details, the terms I'm using are: IF VPM Categorization equals Cost, THEN…
-
Help with Auto Number column formula
Hello, I've pretty new with Smartsheets and most of the time I try to use the examples from other posts that I have seen others put up in order to solve most of the problems that I have. Unfortunately, I cant seem to get this problem to work. I have 3 sheets, Source, Helper, and Destination sheets for an Onboarding project…
-
Update Column with Global Updates without Changing Position
I want to be able to choose whether or not the position of a column changes when I use the "Modify Column" global update. This can be very disruptive to my users if they have rearranged columns on their project sheets.
-
Merged: Contact List Column Should include Group option
This discussion has been merged.
-
Resource Management Adjustable Column Width
Make the column width adjustable by users
-
Hi, Does everyone knows if smartsheet has a maximum column capacity?
I'm having some issues with the workflows cos' sometimes they just stop working and once i run them again, everything works again. So, I think I may be the number of columns the Smartsheet has (about 200)
-
Formula - Helper Column Flag if Duplicate
Is there a formula I can use in a helper column to flag an entry if a duplicate already exist? We are going to share add forms with 100+ people to enter information about their employees. The last time we did this many of them entered duplicate employees causing a lot of chaos. The goal is to send out alerts/notifications…
-
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…
-
Column Formula + Reports
Curious why a column that has a formula applied cant be changed when it's pulled into a report - from the report? Also wondering if there is a way that is quick to remove the formula from an entire column? I've switched one back to 'cell formula' to allow for edit from the report but, would like to avoid running down 600…
-
Apply formula to full column
As lines are constantly added in a workinglist, I want to ensure any new lines will always have a column with a formula filled in. The formula will check certain data in fields on that line to show a specific status/value. I read that i should be able to 'insert' a formula on a full column, but can't find it. I'm only able…