-
Allow Copy Image into Comments
Please allow for images (Snapshots) to be add to comments vs as file attachments. Example: SnagIt Image I want to Copy/Paste to Comments in Smart Sheets Copying and Pasting into the Cell takes up too much space and we should be able to copy image to Comments vs having to Save as a File then Upload a visual as an attachments
-
I have multiple nested formulas but one doesn't return anything... Help
Hi All, I'm trying to automate the status of a project plan. We have 4 statuses, Not started, In Progress, Behind, and On hold / cancelled. Here's what I want to happen: If [% Complete] is blank or = 0, and [Start] is in the future, then "Not started". If [% Complete] is >0 and <1, and [Finish] is in the future, the "In…
-
Ability to Copy or Convert Program Reports
Looking for the ability to copy or convert Program Reports. 1. Copy - The current feature allows you to copy a report, but they default to Sheet reports. 2. Convert - alternately, it would help if a user could convert a Sheet report to a Program report, or visa versa. Either option would be a great time saver to duplicate…
-
Count children rows where multiple criteria is met
I am working on reporting of a tracker to return a "1" in a column for only children rows, where specific criteria are met in other columns in the same sheet. Below is what the AI formula maker returned, but I am getting an error back. Any ideas? =IF(AND(COUNTIF(CHILDREN([BB Label Approval Status]@row), "complete"),…
-
Data Shuttle: Multiple Email and Text Filtering
Hi! I am trying to filter my offload with "does not contain" and then have a string of emails I want to omit from my contacts column. We have contacts that we are not doing the billing for so I want to exclude them. I've tried separating emails with a comma, with quotes, with <> between the email addresses and its not…
-
Looking for an option to Exclude rows from Dependencies/Predecessors
Currently, the only way to exclude a row from the Dependency/Predecessor function is to delete the row. This causes any Dependency/Predecessor reference to the row to change to #REF, which does not break the associated date row, but skips the #REF. Preferably, we would like to keep all rows, but have an option to exclude…
-
There doesn't seem to be an option to delete a post?
There doesn't seem to be an option to delete a post?
-
AND-OR-COUNTIF Question
Hi, I started to build a formula and it doesn't return the required values. I have a sheet for distribution board testing. There are 25 yellow checkbox columns and 24 green checkbox columns. I have a column with 4 colour symbol (L1-Quad), and a checkbox column (All DB Tested) where the formula needs to return the value. My…
-
Formula produces #CIRCULAR REFERENCE
I'd like to compare the dates in two rows, i.e. Ende (Plan) and Ende (nach Verschiebung). If Ende (Plan) is older than Ende (nach Verschiebung) the date should change to red colour (or somehow be highlighted). The AI tool in Smartsheet proposed the following formula =IF([Ende (Plan)]@row < [Ende (nach Verschiebung)]@row,…
-
Form Submission Creating Multiple Rows
Hi there, I know this question has been asked previously in the forum, I'm hoping since that time, there has been more information around this topic. We are leveraging Smartsheet for a core business process and would like to use the functionality of a form as it simplifies the process and removes some of the technical…
