-
Organizing attachments
Hi, Is there a way to organize attachments, so I don't have to scroll through all my attachments? I saw a question like this from 2021 and was wondering if there was a solution. Thanks
-
Auto Delete rows
HI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
-
RYG Arrow Colors
I would like to recommend an additional option to swap the red and green arrows so that there is an option for red arrow = up and green arrow = down. This is helpful for budgeting in project management where at a quick glance you can see if we saved money on an item or lost money.
-
Can I create one:many and many:many relationships between two SmartSheets?
Hello, I have two related SmartSheets covering different aspects of my data. I would like them to refer to each other so that I can ultimately pull certain aspects into a report. I prefer to use SmartSheet over SQL in order to take advantage of the workflow and approval capabilities. However. I cannot figure out how to…
-
Count distinct values within cell
a
-
Trying to Flag Overlapped Participants in Meetings
So I am trying to find a way to flag if there are the same people in multiple meetings. I am working with a drop down type format for the list of participants, so I am not sure how or if there is a way to compare the individual entries of the drop down to other elements in the column to test for potential conflicts.
-
COUNTIFs across multiple columns from another sheet
Hi all, I'm currently struggling to execute a formula to count the number of times a contact appears across multiple columns from a sheet I'm referencing. I know I can just add two COUNTIFs statements for each column but this doesn't solve my problem of only wanting a contact to be contacted once for each row (eg if the…
-
Checking checkbox if the cell on the same row in a different column contains one of several values
Hi all, I'm currently having a little bit of difficulty writing a formula for a checkbox column. I intend to write the formula so that the box will be ticked if at least one of three values (people's names in this context) appear in a different column on the same row. I can get it to check by only specifying it contains…
-
How do I search for duplicate data within a sheet?
Hello everyone! I am very new to Smartsheet and new to my position as a New Product Development Coordinator. My company utilizes Smartsheet to track new ideas for products as well as the progress of the projects done on them. We have a master sheet that all the ideas are filled into from a form showing who submitted the…
-
SUMIFS with OR function (multiple criteria in same column)
Hello, I am trying to get a sum if the criterion in a certain column meets one of several conditions. If the country code equals one of the country codes in the "country" column, I would like to sum the Total MVE for each country code. Right now I have" =SUMIFS([Total MVE]1:[Total MVE]66, Country1:Country66, ="AU",…
