-
Copy Rows Automation
Hello, I am setting up 2 sheets. One Master Sheet and the other - User Sheet. I am setting a copy row workflow automation so that every day at 5pm rows added to Master sheet are copied to the user sheet. Before i implement and test this, i am wondering: Will Smartsheet know to copy only rows added that day(masters sheet)…
-
Configure Google Suite App Access Control From Smartsheets
Hi, I'm trying to automate the population of access control lists in Google Suite apps (Docs, Sheets, etc.) based on a list of names/emails maintained in Smartsheets. Has anyone done something like this before? Thanks! Gary
-
Ability to Find & Replace text in Formulas
Hi Team, I am aware that this functionality isn't currently available. But, as someone who works on rows & rows of data every day, replacing values in a formula using the Find & Replace feature is extremely helpful and time-saving. As I type this, I have the daunting task of going back to my sheet on SmartSheets and…
-
And If But Formula
Hi Brain Trust I am trying to build a formula that will return a count when 2 set of criteria align When Approval type is "Approvals" and Status is "Complete" count the relevant year in Financial Year IE - I want to know how many project "completed" projects we have for "Approvals" in 2023, 2024, ect ect
-
Published Dashboards for external customer facing websites
Does anyone know of any Smartsheet users who has used published dashboards that include metrics, reports (published), and clickable interfaces on an external customer facing website? Basically, does anyone have some real life use cases of utilizing published dashboards from an organization to the public? I could really…
-
Column level permissions
Since there aren't column level permissions, I tried Dynamic view, which would work great if we could utilize proofing with Dynamic View, which is not possible. I have columns a specific group of users should NOT be able to edit on my sheet. However , I utilize proofs. Does anyone have a creative solution to not allow the…
-
{{Asset Name}} in notification & Email
Dear All, I think it may be a bug that sometimes in my notifications (in Smartsheet Bell) and in Email I am getting such name of the asset:
-
Project Roll Up Percentages
Hello - New to SmartSheets so still learning the platform. I have not been able to figure out how to roll up percentages complete for each of the phases (Parent and Child tasks) of a project. Keep getting the #DIVIDE BY ZERO error. I'm lookin to roll up percentages complete on each phase of the project and up to the…
-
Have you seen a change in the time taken to trigger a WebHook?
I use WebHook in a number of places in our Smartsheet system. In the past after a sheet was saved, WebHooks would fire and be received within a few seconds by my servers. Now I am seeing a consistent 60 second delay after save for WebHooks to contact my servers. I think this change has happened in the last 6 months. For…
-
Formula Multiple Parameters with Multi-Sheet Reference
I need to create a set of formulae using references to another sheet to: 1). count the number of different types of reports due within the month of January, and 2). the number of those reports delivered on time. For the first formula I tried: COUNTIF({{Report Type}}, OR(@cell = "Report Type 1", @cell = "Report Type 2"),…
