-
Is there a prettier way to write this formula?
Is there a prettier way to write this formula? =IF(MONTH(Finish@row) = "1", "Q1", IF(MONTH(Finish@row) = "2", "Q1", IF(MONTH(Finish@row) = "3", "Q1", IF(MONTH(Finish@row) = "4", "Q2", IF(MONTH(Finish@row) = "5", "Q2", IF(MONTH(Finish@row) = "6", "Q2", IF(MONTH(Finish@row) = "7", "Q3", IF(MONTH(Finish@row) = "8", "Q3",…
-
Is it really free in app store?
On the website, it lists the pricing as the following But in the MS app store, it is listed as free: The only thing that is blocking me for trying the app is that it requires a work email and my phone number to proceed. Can someone clarify whether it is indeed true in app store? And what is the "price" to pay? (Giving out…
-
How to restrict by Filter in Dynamic View?
I remember there being an option to restrict a view in Dynamic View by a filter that is in the source sheet. It is no longer where I remember it being in the settings under general info. Can you tell me how to find this? I changed my filter so that it is not shareable. Will this result in the viewer only seeing the…
-
Favorite a Form in the App
Hi is there a way to favorite a form in the app.. every time there is an update with the app - my staff lose the forms in their recent tab and i have to send it again. so is there a way to favorite the form so i don't have to go through this exercise with 500 people every time there is an update. This form is important…
-
Project Provisioning into its own workspace
I have a question regarding provisioning a project into a work space using control center and tiles. Here is the scenario Lets say I offer 10 different project types. So I have 10 different workspaces that then can get created specifically for a client based on what project type they purchase. Client purchases project type…
-
Copying data from Smartsheet to Excel with Power Automate
Hey all, I'm trying to back up my smart sheet important data by copying it into an Excel sheet. The issue is that I get array of rows that should be the column of the row that was copied from smart sheet. See attached pictures. I don't understand why I cannot get a variable for each column in specific row Data On smart…
-
Document uploading from Onedrive
We are trying to set up Smartsheet to upload documents from a Onedrive shared account, but we are having problems because Smartsheet only presents me the option to select files from my own personal OneDrive (for Business) storage, not the Sharepoint sites documents that I have also access to through OneDrive. We achieved…
-
Docusign/Generate Document
I have been using DocuSign/Generate Document from the beginning. Is anyone else experiencing this scenario? The process is used on a quarterly basis, today when attempting to generate documents from an existing mapping that was last accessed on 4/22/21 the message popped up "An Error has Occurred" "We're sorry, something…
-
Datamesh Error Code 5537
One of my users has recently begun to receive an error message when executing DataMesh. The message is: Warnings 1: error code 5537; message: Only sheet admins can override validation There have been no recent changes to the source or destination sheets or to the DataMesh configuration. The user holds Editor-Can Share…
-
HTTP Call syntax
Hi Smartsheet Bridge community. We are pretty excited about enabling BRIDGE. Have hit a roadblock and suspecting the sytax we are parsing is incorrect for a HTTP Call. When running a CURL command to copy an existing sheet this is what we running - and works successfully. The trigger is working fine. The following error is…
