-
How to create a countif formula with OR
I am trying to create a formula across columns with different values in a cell. I have the formula for one value, Preliminary Draft. This works fine. =COUNTIFS({Comments Log Range 1}, [Document Name]@row, {Comments Log Range 2}, "Preliminary Draft", {Comments Log Range 4}, "Open") However, the value in range 2 can also be…
-
Report on User Access when Users are not Registered in MY Smartsheet system
We have an application that has been built on Smartsheet. Several of our clients have the users of our system as Licensed (or unlicensed) Users in THEIR Smartsheet system. Because of this - we cannot add them in our Smartsheet system. We would like to get a report that shows the utilization of OUR system by THEIR users.…
-
How I can obtain a month's name from a date?
Hi folks, Has anyone knows how I can obtain a month's name from a date? It's like a FORMAT([Date]; "MMM") that returns something like June. Regards, J. Morais
-
Extract List of Unique Values
Hi Is it possible to use Bridge to extract from a column a list of values, run a JS to extract an array of unique values, and then pass this to another sheet and update another column with this unique list?
-
Bridge Salesforce API - SF Contact Module
We're looking to pass contact information associated with Salesforce opportunity records into Smartsheet. We have the Smartsheet / Salesforce Connector in place, but following the current structure would explode the number of fields necessary to denote all possible roles associated with each project. Is it possible to…
-
How to format "row" when inserting record into Smartsheet
Hi - i have a Power App where i am assembling data to insert new row in SmartSheet and continue to receive "unable to parse insert row request payload". I have formatted the row via "Compose" action a few different ways to no avail. Here is latest attempt - note that I am replacing the variables('... using dynamic content…
-
API PUT and Body help for Cell link from a cell in sheet "a" to sheet "b"
I am having trouble linking a cell from sheet a to b. I am new to using API and possibly just getting the call wrong? or the body. Any help would be appreciated. PUT: https://api.smartsheet.com/2.0/sheets/4098048888098692/rows/1370574824361860/cells/259016080 Body: { "cells": [ { "linkinFromCell": {…
-
Why were all SDK GitHub repos archived?
I see that all of the Smartsheet SDK GitHub repos (https://github.com/smartsheet-platform) were archived earlier this year. In GitHub, archiving a repo makes it read-only and indicates that it's no longer being actively maintained. Can you please shed some light on why these repos were archived? Are they being replaced…
-
API Access Tokens for non-licensed Users
I've seen varying information about who can generate an API Token. For example, I am a "free" unlicensed user who has access to a licensed user's sheets. That licensed user is part of the Enterprise plan. I am setup as a "Viewer". When I try to generate a token, I get a message saying I need to Upgrade my plan. Can anyone…
-
Smartsheet app authorization
Greetings, Looking for a little guidance. I would like to develop an app that sends data to a sheet through HTTP. I have used the Python SDK with a raw token in the past but now I need a more secure solution and figured creating a 3rd part app is the way to go. I am having trouble with the workflow. Whilst following the…