-
Collapsable vertical header list to hyperlink to column
In the same way that Dynamic views and WorkApp resources listed on the left can be collapsed or expanded, I would like to see a searchable, sortable, vertical column with scrollbar that lists the headers of all columns in the sheet. Each column header name would hyperlink directly to the column I want. I have 80 columns in…
-
Due in Days and conditional formatting question
I have this formula (below) to calculate my "Due in Days" column, and a conditional formatting rule that states "If due in days is less than 0" then apply a red font. but I'm wondering if I'm able to have it display no number once the task has been completed, or at least remove the red font once the "Status" column…
-
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…
-
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…