-
Searching in Smartsheets - doesn't show ALL possible results
We're having trouble smartsheets in our office because when we try searching for a particular item, it doesn't show all possible results. Is there a setting that we should change to be able to search and view all possible results? As you can see on screenshot 1 the results do not show when I search for CL035 even though…
-
Update Schedule on Mobile.
I am new to the forum, so if I am not searching correct terms please let me know. And if there is already a thread on this directing me to it would be very helpful. I was wondering if there is any way that I can actually update a schedule (finish dates), on a mobile device while I am walking a site? I have both Android…
-
countif help
Hi all, I'm trying to figure out a way to sum the number of one column if it has the value of another column. The formula I was trying is: =COUNTIF(Scoped:Scoped, Channel22) I want to know how many are scoped in the scoped column if the channel header is in row 22. It's reading invalid. Any other ideas?
-
Create RYG Balls for Children
I've spent hours attempting to display RYB Balls for three different drop-down status. "Not Started" "Pending" "Signed" The goal is to have a "Red ball" display in the Not Started Column for the drop down "Not started" in the Quote status children. The formula I'm attempting to adjust - =COUNT(CHILDREN([Quote Status]2 =…
-
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition. Because we share our SmartSheets with multiple teams, I would like the ability to add…
-
Feature Request: view attachment thumbnails inline of comments
I would really like the see a good sized thumbnail of the attachments I put into my comments. This will often save time from having to click on the attachment and have it open in an overlay like it currently does. Asana does a great job of doing this (see screenshot - blurred out comment and image for privacy of my…
-
Help needed with an If/And formula referencing another sheet
Thank you for taking a look at this. I have one sheet where I am trying to show the count for a person on another sheet IF another column has a 1 in it. The 1 represents a checkbox in the ajoining column. For some I have tried looking for the specific name (where you see Courtney) and others had the name listed in a column…
-
Calculate days since a bubble turned red
I have a column that shows red (off track), yellow (at risk), or green (on track) depending on whether a date column (completion) is before or after another date column (goal completion date). What I'd like to show is the amount of days since a bubble turned red. This would tell me how many days it has been since a project…
-
Help needed counting across sheets
Hi all, I am trying to use the count of a symbol across some sheets. I know I can get this information by creating a report but for a more visual presentation, I am looking to get an actual number. I am currently trying something like this but it's not working: =COUNTIFS({sheet 1 Range 1}, 1, {Sheet 2 Range 2}, 1) The…
-
Non People resource assignment
Hi Hoe do I assign non people resources to a task. e.g. a piece special equipment to do a job so that I can see the utilisation of the equipment.