-
Centrally Manage Drop Down Lists for Multiple Sheets
I work with a small Real Estate company and we lean heavily on Smartsheet for all of our task and workflow management. We have built a system of task lists, workflows, and meeting agendas that all work very well, but at the moment we have to edit drop-down lists manually sheet-by-sheet. I've searched the community for ways…
-
CMMS Build up
Hello, Am working with a company as an IT which needs a CMMS tool for their mining clients for the WR, WO, PMs, AMs and so forth. And I need an expert of Smartsheet to help me on contract to develop the tool for them.
-
remove column ids, row ids from Smartsheet json!
hi team, I need help with removing the overheard data from the Smartsheet api call that returns a json file, I need to remove all the overhead before putting the data into the pipelines, thanks.
-
Navigate URL Automation
Hi Team, Is it possible to automatically navigate to a URL added in a cell if specific cell value changes to specific value? Please see below to understand the requirement. I have a tracker sheet for each project. Each tracker sheet having multiple task and once all task completed a formula cell shows to project completed…
-
Can Smartsheet get data from custom HTML forms on a website?
Hello, If I'm building a website, can I create a custom HTML form and get the data into Smartsheet somehow? Smartsheet's native forms don't have the capabilities that I need (conditional logic) and I would like to make my forms a bit prettier. Thanks in advance!
-
Any way to use a cell value as a row number in another cells formula?
Hi all Anyway to get the row # from a cell value and use it in a formula? Example this works: IF(COUNTIF([Assigned To]$974:[Assigned To]@row, [Assigned To]@row) > 1, "DUP”,1) Now let's say Column1 row 23 contains the value 974 I would like to do this: IF(COUNTIF([Assigned To][Column1]23:[Assigned To]@row, [Assigned…
-
Taking a dashboard "snapshot" as a pdf and attaching to a given row
While the header of my question seems confusing, hopefully an easy solution exists somewhere. I have a complex smartsheet's dashboard created which has metric widgets filled with values that update every time a new form is submitted to a sheet ("sheetX" for later reference). What I want to do is try and capture a part (or…
-
Update date field error
Hi. I'm trying to update a cell on a row which is a data field using the C# api. However, I'm getting an error {"Value is not supported for this column type. Use objectValue instead."} But when I'm trying to set objectvalue i get an error due to protection level I know I'm doing something wrong, but i dont know what :P
-
Dashboard Charts are Blurry/Fuzzy
Hello all - I am building a dashboard and wanted to include a few charts. However, my charts come up fuzzy, regardless of size. See below. These are pretty nicely sized on my dashboard and still showing blurry. I saw from a post in Nov 2018 this was a known issue. Anyone else have this issue? Any fixes or updates? Thanks!
-
Attempting to convert data from check boxes to Multi Select Dropdown
Thank you in advance for any help you can provide. Since the Multi Select Dropdown option was not around when we created our form, we used a variety of check boxes to gather the required data via a form published on our website. Now that the Multi Select Dropdown is an option, we would like to migrate that data over to a…