-
Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
-
Find information within a formula
Hello, I am trying to find information within formulas that reference a given cell using CTRL + F. The data is in the cell [2028 (CY)]214. I have tried the following: [2028 (CY)]214, *[2028 (CY)]214, = [2028 (CY)]214, = * [2028 (CY)]214. However, it returns 'no matches found'. Does anyone have advice or is this not…
-
Attachments with Widgets
I have a dashboard that has a report widget and I was wondering, can that widget also show the documents attached to a row so you can click on them or is that only in the sheet?
-
Datasources for Dropdown Menus
A sorely missing feature from Smartsheets right now is the ability to link dropdown menus to a central datasource - currently when designing sheets with dropdown menus, you need to manually update every sheet where the list exists making change management a pain. If we could populate those dropdown menus from a reference…
-
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…
-
Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
-
Does a view-only user need a license to use the API?
Hello everyone, I will need to use Smartsheet API to ingest data from Smartsheet to an object storage. To do that, my client will create a view only account for me. If I understand correctly, to use the API the account needs to be licensed, so we will need to pay for this "service account". That is correct?
-
To implement "Fill handle feature" in Smartsheet Mobile App.
As a frequent mobile user, I am writing to suggest a key feature addition: the ability to drag and copy data in cells (Fill handle feature) within the Smartsheet mobile app. This desktop feature is a major time-saver, and its absence on mobile creates a workflow gap(As I have experienced I am not able to copy the data from…
-
Introduction
Hi all, my name is Vesna and I work as a senior project manager in regulatory affairs for medicines. I am so excited to use the Smartsheet!
-
Form Submittal Error
Hello, one of our users is getting this error when trying to submit to a form. Other users are able to submit to it without a problem.