-
Count Rows in Reports
Currently there is no way to capture and report the number of rows in a report (or across multiple reports). It is common in dashboard reporting to create a metric (or card visual) to count the number of specific items in a table by simply allowing an application to count the number of unique or distinct rows. For example,…
-
Using Sheet Summary To Populate Columns - and Have Same Restrictions
I'm using a sheet summary to add some global sheet data (i.e., it's not associated with rows, it's associated at sheet level.) I've got a sheet summary contact list field where I add the project manager - then it populates the top cell in a column. I then use this cell as an email recipient in a workflow. However, it…
-
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…