-
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…
-
How to update a column formula for new ID prefixes
Hi everyone, I am not sure if I am going to explain this correct, but here it goes: Last year, with the help of engineers at Smartsheet, I had built a project management suite for one of my agency divisions. We have everything from dashboards, to meta data and archive sheets. I wanted to replicate this management suite to…
-
"Created By" column limitations?
Context: We have a Form that was created about 5 months ago for Tech Request Tickets for our company (all internal). Within our company, we all have Smartsheet accounts. We had an issue of auto-population within our form; we couldn't seem to get an email format when people were submitting requests, only the first name was…
