-
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'…
-
Formula(s) for calculating past due items on a construction punch list.
I'm creating a simple punch list template and would like to add some date calculating functions to it but I'm very unfamiliar with creating date formulas. I'm attaching a screen shot of this rough template with a sample line already entered. I would like to create a formula that will tell me how many days past due items…
-
Count if formula and task progress
Hi, I've been trying every way possible to set this up so hoping someone can assist-- I would like to create a dashboard with a pie chart that shows how many tasks with a due date for the past 30 days from a sheet are done or incomplete. This seems simple enough, but Smartsheet keeps telling me I can only use numeric…
-
Hyperlink to external drive
Hi all, I'm looking for a way to enter a hyperlink from another local shared drive in a Smartsheet cell. Is this somehow possible? Thx for your help! Warm regards, Gonnie
-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…
