-
Formatting
Hi, I’m trying to set up conditional formatting in my plan and need some help combining two conditions. Scenario: If the T-Start Date is in the past, I want the date to turn red. However, if the Status cell is Green, I want the T-Start Date to show as green instead of red (so the Green status overrides the red formatting).…
-
Dashboard Content Moving
This has happened several times randomly to different dashboard: My dashboard content: title bars, metrics etc. will scatter and relocate to random locations creating an unorganized mess Have not determined a "pattern" i.e. does it occur after editing/saving, does it occur when dashboard has not been viewed in a while,…
-
Data Shuttle Date Formats - current crazy conversion
Need to be able to specify date formats in data shuttle OR for it to adhere to the formats in the uploading CSV file and/or smartsheet. For example: I have a CSV file to upload via data shuttle with date dd/mm/yyy. The smartsheet has the regional date setting of dd/mm/yyy BUT data shuttle takes a "best guess" and is…
-
countif from 8 different sheets with data criteria
Hello, I have a head scratcher here, I have 8 different sheets that I am trying to pull counts from and only from a certain day. Example: All sheets have a date of outreach, all sheets have a outcome. I want to pull the count of all outcomes marked "Mbr Reached" from 12/02/2025 from all 8 sheets. Question: Is there a…
-
If Approved Path On Request Approval Issue
Hi Everyone, I'm having a heck of a time getting this automation to fire right..it requests the approval fine, but it won't do anything past "If Approved". I've even tried shifting the approval alert to it's own workflow with no luck. That one would say that it fired, but no notification came through..this is in a test…
-
Getting Blank Rows While Inserting Data directly using Python
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…
-
Timeline View Conditional Formatting Color Not Updating in Real time and requires refresh of page
I have a grid sheet with formulas and conditional formatting set up so that when the Status of a row/task changes, the row color and icon update accordingly (e.g., when Status = “Staged,” the row turns yellow and shows a yellow icon). These colors have always carried over correctly into Timeline view. Previously, if I…
-
How to Auto-Check a Checkbox in Sheet B When Project ID Exists in Sheet A Using DataMesh?
Is it possible to configure the DataMesh field mappings so that the checkbox in Sheet B is automatically checked when the Client ID exists in Sheet A
-
dynamic view not loading correctly
I am not able to sort or filter correctly in dynamic view.
-
Substitution for COUNT/COUNTIF Function
I am trying to pull information from a shared sheet that is considered the intake for all projects to a metrics sheet for a count of items per each calendar month that will be used as reference for a metric dashboard. The month column was hand typed at one point but was recently replaced with a column formula to…