-
Sort by month and year
I'm trying to summarize a sheet that has data from Sept '23 - Sept '24. I'm using this formula =COUNTIFS([Study Type]:[Study Type], "SOW", [Date Received]:[Date Received], IFERROR(MONTH(@cell ), 0) = 9) to sort by project type and month, but it's combining everything from September '23 and September '24. What can I do to…
-
Help automating a duration
I have 2 check box columns one is Start time one is stop time, how can i create a formula to pull the duration in hours between when start and stop are checked? I have automated to capture the date when box is checked but i really need the time in hours.
-
Smarter Dashboards
I would like to know more about Smarter Dashboards. Are they a separate entity, or can they be created using the existing sheets and dashboards in my workspace? How do they work? Can I create them myself, or would I need assistance from Smartsheet?
-
Bridge - blank field in source sheet should be blank in the destination sheet
This discussion was created from comments split from: Anyone know how to use "update row" in Bridge to add a Contact to a cell?.
-
If Formula
=IF([Invoice Review Status]@row = "Approved", 0, IF([Invoice Aging (Days)]@row, <1, 1)) Im getting #Invalid Data Type when the aging days go over 0
-
Charts
Why are the columns in the first chart all showing the same. I tried to change the color but when i hit the drop down my other categories are not listed. Only option is Column3. This is my metric sheet My formular for Quoting: =COUNTIFS({Order Tracker Template Range 2}, @cell = [Primary Column]@row, {Order Tracker Template…
-
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…
-
How to Export or Save Filters with a Published Smartsheet Plan
Hi Smartsheet Community, We have a published version of our plan, but when someone tries to export or save the plan, none of the available or created filters are included in the export. Is there a way to enable the export or saving of filters along with the plan? If not, does anyone know of a workaround that would allow us…
-
If Formula
=IF([Work Performed Total]@row / [Employee Count]@row * 12 = 0, [Revenue Projection]@row / [Employee Count]@row * 12) Why is it if the work performed cell is greater than 0 then the answer is blank? I want it to use revenue projection as the normal answer until work performed numbers start getting entered
-
Approval Workflow
I have a approval workflow automation set up but am looking for a way to add comments to when the request is approved/denied without having to send another update request. Is this possible? I have it set to notify someone when a request has been submitted for approval. The user can review the request from the 'alert…
