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…
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,
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…
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…
This discussion has been merged.
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…
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,…
It would be great to have user definable fiscal quarters in the new Timeline view. Also, as I am creating this discussion, there isn't a tag for Timeline View yet 😁
Cascading Form data sets is one of Smartsheet's missing capabilities that I believe would be a game-changer for many alternative providers. Cascading forms are a very effective technique that can be used to compress form data and limit down options in order to narrow a workflow or collect more accurate data. Recent usage…
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…