-
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…
-
Easily identify all Reports impacted by a column change or removal
Need a way to proactively search (query a 'where used') on a column name to see all the Reports its used in.
-
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…
-
is there a column number function for vlookup?
VLOOKUP requires a number for the column position in the table reference. But I have users who have been known to insert columns into the referenced sheet to the left of the needed column, throwing off the returned value. Is there any function I could nest inside the vlookup where I could provide the column *name* and…