-
How to add a row through a form entry
Hi, I am super new to Smartsheet. I am collecting information on products through a form with the product code being in the primary column (one row per sheet). I would like to enhance this form for the user to be able to enter the information of multiple products so that every time the user enters a new product code, a new…
-
Adding two COUNTIFS
Hi, I am trying to add two COUNTIFS from different sheets and using the formula below. =COUNTIFS({Engineer Live Rota}, $Name@row , {Date Live Rota}, >=DATE(2020, 2, 1), {Date Live Rota}, <=DATE(2021, 1, 31) + COUNTIFS({Archived - Rota Range 1}, $Name@row , {Archived - Rota Range 2}, >=DATE(2020, 2, 1), {Archived Rota Range…
-
Proofing automatically assigning reviewers.
Hello there, We have a few workflows in which people review at different times, not at the same time. This ensures that our "final checkers" are not getting blasted with review requests before the proofing item has gone through a "peer evaluation" . If there isn't already, could a way be created to have items in a specific…
-
Proofing - Previous draft
When you click an "invited to review proof" notification link in the email, it automatically launches a new browser tab and loads the new proof. You cannot however quickly toggle to previous proofs from this view. You have to go back to the associated smartsheet to and reload the proof from there to be able to see all…
-
Update Notification Bell to Add "Proofing Requests"
Managing feedback for multiple proofs in multiple sheets can be extremely tedious, especially if relying on the large number of emails at your inbox for "Proof Accepted" or "Proof Rejected." Clicking through to each proof only to learn that you are still waiting on others to review, is very time consuming. If not keeping…
-
Email Alerts
I’ve noticed a discrepancy in my sheet's automated alerts. While the team is receiving notifications for all changes, I am only receiving alerts when others make modifications. I am not being notified of changes I make myself, despite the automation being set to alert for all updates. Could you help me check if there is a…
-
Mapping Diagram/ Export Documentation of workflows
Can the automation workflows be exported into a mapping configuration for documentation and recording purposes? Is there a tool or app that anyone uses for this? Part of our IT process is documentation, and having a way to explain in a visual mapping of all the sheets, reports, workflows, and dashboard components would be…
-
Can I use the api without a business plan or can I use a business plan for a short while
I am attempting to use the api at my house on a completely different account then the one I actually used at work as I am trying to determine if I can correctly configure the api to perform some mostly basic actions of quickly converting existing smart sheet tables to excel. I have determine ways to possible do this just…
-
countifs not working via choosing whole column or selected cells
Dear team i try to count the delayed task using Countifs. But this formula is not working either manually typing my column header or choose whole column or selected cells. So my asking is how to add the range fast and correctly?
-
Metric Widgets Not showing Sheets
*Edit, nevermind, found out why. :) I am trying to build a very basic proof of concept dashboard for the business before we decide to buy license however, whenever i try and create basic metric widgets from the reports i have created (which match the widgets/sheets from the templates which shows sheets fine), they are not…