-
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…
-
Access (visibility and the option to edit) to SOME rows in a sheet
Hi, First, thanks for members of this forum, you’ve been a great help! I have one main sheet where all (different) legal tasks are listed to help the legal team manage the work load. Only the legal team has access to this sheet. One of the departments however, requires visibility of their related tasks, therefore I have…
-
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…
-
Highlight next date
I can't find a way to conditionally format a date field to highlight the closest dates only. For example, if sheet has: 08/30/2018 08/30/2018 09/04/2018 09/04/2018 09/13/2018 I want to automatically highlight the 8/30 dates. They will fall off the sheet after the 30th, so then the sheet should highlight 09/04 rows. Is…
-
Formula and RYG balls
HELP!!!!!! How do i create a formula to use RYG balls in the status column with % Complete column no matter how many videos and threads i look through!! I have a status column I also have a % Complete column I want to use balls to show how complete a project currently is i want Red balls to show projects that are less than…
-
Formula Returning Today's Date IF Column is Value
Possibly a dumb question... I am trying to format a date cell to return todays date if a cell in the same row is marked "Completed" using the IF formula. I am using the TODAY() formula as a result in the IF string, however it looks like the today formula cannot not work in this way: =IF(Status111 = "Completed", "TODAY()",…
-
Auto Status Change/Update
Hi, I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08/24/2018 and it is 08/25/2018 and the status box of completion is not checked yet, is there a way to create…
-
Add additional filter or how to do this
Hello, I need help to do something if possible. From my table, i want to make a filter which will show just the rows which has the specific terms. Ok, this is easy and I know how to do this. My issue comes when I have one more column where the fields containing numbers from 1-5. So, I want to somehow make additional filter…
-
Data movement between sheets
Hello! I'm new to SS - is there a way to use conditional formatting to have data move between sheets. For example, when a cell has a specified value, the row is copied to a different sheet? Thanks in advance!
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…