-
Why are Non-Working Days set in Admin Center not feeding into new sheets?
Hi, New sheets generated via the save a copy method are not picking up the global non-working day dates set in the Admin center - are they considered to be generated from a template and therefore do not pick up the global settings?
-
IF Function to Add Quarter and Year
Hello, I am editing a smartsheet that tracks tasks. I have a column for the quarter that needs the year based off [End Date]@row for all tasks added after the calculated quarter. I am using the formula: =IF(ISDATE([End Date]1), IF(MONTH([End Date]1) <= 3, "Q1", IF(MONTH([End Date]1) <= 6, "Q2", IF(MONTH([End Date]1) <= 9,…
-
Can we pull the capacity % information from RM to Smartsheet?
Hi, I am wondering if there is a way to pull the capacity % for the disciplines and roles that's already provided in the Capacity window (under the schedule tab in RM - snippet below) back to Smartsheet? The reason is that we are in the process of having 3 different RM workspaces for 3 different entities, however, the top…
-
Smartsheet API Call
Hello Team, Please let me know the best way to make an API call from Smartsheet to request data from another tool and how to handle the response. I know I need to use a GET request to make the API, call but I am not sure how to handle the response in Smartsheet. Many Thanks,
-
Control Center (can dos v cannot dos)
Does something like this exist? Just getting into working with Control Center and I keep stumbling across things I want to update/cannot update, so I started this (in early draft mode because I thought I'd ask here before I created this for myself). I am trying to find out if I can update the file names/folder names that I…
-
Row # on Another Sheet
Hey! First thanks in advance for looking. Is it possible to get the row # on another sheet? I want to know the Row # for New: Release Update Sheet. New: Release Update Sheet Release (would require Is Parent to be checked) Row ID (Auto Number) Release List (This sheet is where the formula would go) Releases Auto (Auto…
-
Merged: Favorites List Sort/Display Order
This discussion has been merged.
-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Can I pull columns in different Sheets in one report as long as Primary Column is the same?
Dear All: I tried the Community and I came up with nothing. Can I pull different columns in different Sheets in one report as long as the Primary Column is the same? The columns I need exist in different Sheets, not all Sheets have all the columns. However, the Primary Column is the same (“Interpreter Name” as Text/Number,…
-
Looking to track cleanings
Currently I'm looking to add a validation mechanism to a sheet and would like to have a systems that reports after (X number of) cleanings have been completed for the day. This would add a row displaying the room that was complete for the day. If the room was not complete it would show up in red as not complete. I'd also…
