Using the Attachments, Comments, Proofs and Row Indicators Columns in Formulas.

It would be really awesome if we could use the "Attachments, Comments, Proofs and Row Indicators Columns" in Formulas. Just as a reference point. "Like Helper Columns"

Example, if there is a update request pending, I could then reference that column to do XYZ if there is or is no attachment. same with the rest of those other columns, and combined with automation it would really open a lot of extra functionality to Smartsheet's

Thank You and Kind Regards!

Brandon Austin

Sign in to vote!

Find more posts tagged with

Formulas

Idea Submitted

Comments

Bob Wiedenbeck

I have the same desire, but for use of the locked status in CardView sorting. I have a column formula which identifies whether an action item is due soon, overdue, completed, or due in the more distant future based on an evaluation of target dates and current dates... but that process doesn't allow for 'header' rows in the sheet... like navigation links to other sheets, and/or Parent rows for Open or Closed items. So, my column format treats all of these header rows as "overdue" (since I provided for all actions/rows without a target date defined to be classified as "overdue", {needing review}). This puts all of these items into the Card View when they don't really belong there.

I can also see where reviewing a sheet, or when generating a report that retrieves rows, some of which might have comments or attachments, it would be nice to be able to highlight those rows in some way so that attention is brought to them as having additional information available for review (this is not currently seen visibly in the report other than the small comment balloon or paperclip icon). This would require Conditional Formatting on rows based on Comments and or Attachments Row Status Indicators being flagged.

Quick Links

Trending ideas

Report Widget Capability - Drag & Drop to create Report Widget in Dashboard from Workspace Panel
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
Asset Sharing should default to View, not Edit
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.