-
SUMIFS with multiple OR criterion
Hello there, I am using the function : SUMIFS( range, criterion_range1, criterion1, [ criterion_range2, criterion2... ]) How can I have multiple values for criterion1? I mean, I have multiple values which any one of them will satisfy the requirement, and I want to add all. E.g. I have a list of many names (in another…
-
Show schedule gaps in parent Gantt View
Hello, Is there any way to show the gaps in the schedules for child tasks in the Gantt view. Currently, the parent shows the minimum and maximum dates of the child and displays a continuous graphic, even if there are gaps in the schedule of the child tasks. Can anything be done to display these schedule gaps in the parent…
-
Is it possible to stop a flow pulling in a duplicate line item
Hi all, Hope you are all well! With the help of this community i have created a form that will automatically identify how a line item and how long it is before being cancelled. This form will then send emails to Project Managers once we are 5 days away from cancellation and then a day away. Because of this, we are going to…
-
How to set up a field with multiple entries in a form?
I need to create a field that has multiple entries in a form. I prefer not to create several columns (I need the respondents to make 7 entries, hence 7 columns should be created). Does anyone have a suggestion on how to do that?
-
Need help ASAP on this
Whenever a new otb number is added it should capture it when you select otb number show new otb number as a choice and take you to the url link of that otb number only. I am asking on how exactly would I configure this without having to add manuel filters by whenever I enter in a new OTB number in the smartsheets it will…
-
Has anyone embedded a Clari Dashboard into Smartsheet dashboard?
I looking to build a Dashboard that content Web Widgets to both PowerBi (done) and Clari (Sales AI platform). I have a URL from Clari but it always throws an error and likely becasue it is not the right kind of "embed" link. Trying to figure out if it is possible.
-
Can you embed a Smartsheet Dashboard into a Google Sheet?
I am the only user of Smartsheet & the whole company has a metrics google sheet that we review once a week, is there a way for me to embed the dashboard into the google sheet so I don't have to take a screenshot weekly of it?
-
Viewing a report with a basic account (not upgraded)
Hello, Am I able to share a report with a group in a workspace which has not upgraded to a premium account? I tried doing so but they are unable to view the report. Am I doing something wrong? Is there a particular setting that they need to on in order to view the report?
-
Copy the same row multiple times through automation
Hello All, I have built an automation workflow after a Checkbox is checked to copy the row and move it to another one. The source sheet and the destination sheet are 2 steps in our process workflow but I the first step is typically done multiple times. This requires the operator to check the box to move it the first time.…
-
Moved Folder - Contents Disappeared
I am the owner of a workspace and all the contents within. I just moved a folder out of the workspace into my sheets. When I opened the folder in the new location all of the sheets have disappeared. I've searched all through my folders, sheets, deleted, etc and they are nowhere to be found. I've contacted support but that…