-
Report filter that includes "Today" correctly shows the rows on the report, but not when displayed v
I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past. For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future. When viewing the report directly, the report is correctly…
-
Looking for a requirement template in Smartsheet
Hello, I am looking for a requirement template, does anyone know of one or has built one already?
-
Macro Functionality
Hi, I am using SS to track projects. At the top of my SS I have a master list of tasks with sub tasks. I expand all this out to copy the whole lot and paste them back in at the bottom for my next project. SS does not allow you to simply copy the unexpanded parent row and copy all child rows. My question here is as follows.…
-
Default Card View Always Show Field Labels Caret Toggle
How can I force Card View to always show the field labels associated with data on all cards? I don't want to require users to click on the little caret symbol that toggles labels to display on each card... I want all field labels to always show on all cards all the time.
-
Modifying resource views
Good day and thanks in advance! Doing as I understand it's supposed to, when i open a resource view and select (and expand) a resource, all sheets with that resource are there and roll up to the total resource allocation for that resource. My challenge is that I have multiple earlier versions of plans I've developed, with…
-
IF/AND Formula
I am trying to create a formula for when two approval columns have 'Approved' in their dropdowns to change two other dropdown columns. When "APPROVAL Status - BOB" = "BOB - APPROVED" AND When "APPROVAL Status - JOEL" = "JOEL - APPROVED" THEN "Approved?" column will change to "Approved" AND "Issue Status" column will change…
-
Auto-hiding rows
Not sure if this is possible, but I would a row to become hidden based upon the status of a drop down. If cell is blank, nothing needs to happen. If cell is "delete" or "archive", I would like the row to become hidden. Any help would be awesome.
-
how to build an interactive dashboard
If I have a dataset looks like below: Project_ID Approval_Status P1 Approved P2 Declined P3 In approving P4 Approved is it possible to create an interactive dashboard showing the approval status of each Project ID? and Project ID put into a drop down frame on the left of the dashboard, user can select any of Project ID in…
-
Is my alert too redundant?
Did I set up this alert to be too specific? I want to have an individual notified when a row to which they are assigned to has the status change to "In Progress". I'm trying to test it now but have doubts about the "In a row where any status is In Progress" line I included. The red in the picture is where my colleague's…
-
Estimated Durations
I ma moving from Microsoft Project to Smartsheet and trying to replicate workflows that have served me well for decades. In Microsoft Project, I can indicate that a duration is a estimate by including a question mark, for example 5d?.I use this heavily as placeholders when building a plan so that I know that I need to get…