-
Automation column to column
I would like to automate the behavior of columns. My case is to create a list of our department's contacts as task assignments and in a separate column note the team the person is on, so, for example, Jane Smith is on the Marketing Team, and John Doe is on the Operations Team. Then I would create a USER REPORT for tasks…
-
Allow unlimited deletion of columns like Excel
A major value proposition of Smartsheet is that it can replace Excel. It's then a huge shock to users who have been asked to move to the new Smartsheet platform to find that it allows up to only 5 columns to be deleted at a time. I have seen Smartsheet's response, that the limit is to ensure integrity with the server due…
-
Automation workflow assigning people in a Contact List column - list doesn't match
Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the "Assign People" action and the "Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…
-
What happens when the attribute names (column names) are changed?
We have a few dashboards which use the data from certain attributes (columns) in a sheet. We've recently decided to change the names of these attributes. What will the impact be on the dashboards be? + Is there an effective way to change the column names in all the cells that reference said columns at once instead of going…
-
Modifed By and Modified Date changes in each row when sheet is viewed
Hi all I am having an issue with my "modified by" and "modified date" columns. Sometimes, but only sometimes, when someone views the sheet, it changes all rows in each column to that person and that date, effectively erasing the data beneath. It seems the culprit might be my TODAY formula, which is set up like so;…
-
Sheet Summary Report Isn't Populating Columns
Dear Smartsheet Community, Help! I have 4 identical budget sheets that I would like to report/summarize. I can only assume that the Sheet Summary Report is the perfect solution. After I create the report and subsequently select add my sheets, it then askes for me to select my columns, but then doesn't show them. It only…
-
Formula Question
I am trying to find metrics on everything that is not multiple things. This is a drop down column that has a list of options and I need to exclude from the count CEG 1, CEG2,...., CEG7 I attempted to use this formula =COUNTIF({ColumnReferencetoSearch}, "<>*CEG*"), but the total it gives me is incorrect (2653). I know this…
-
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…
-
Clone Column(s)
When creating a large sheet that will be filled out by a form, I often have similar sets of questions that I'd like to clone (and then modify). For example: Column 1: Text1 Column 2: Checkbox1 Column 3: Date1 If I need to make additional copies of these 3 columns, it'd be great if I could do that easily instead of having…
