-
Grouping Automation - is there a way to checkmark a group of users based on one singular check?
I currently have a sheet in the following format: Primary Owner Secondary Owner Group Title Username Access Status Primary & Secondary Owner - contains names of owner Group Title - group name of which users belong to Username - user names Access - checkbox column (default value is 'unchecked') Status - dropdown list (Open,…
-
Pulling column from one Smartsheet to another, automatically updates
Currently, there is a form linked to a Smartsheet that automatically updates every time the form is submitted. I need to graph data from specific columns, which I want to be in another sheet for visual clarity. From what I understand, I need to pull that data into the sheet I am charting in before I can plot it. What…
-
Formula Help Needed
Hi all, I have a sheet "Transition Tracker" where my team adds data that can often change throughout the lifecycle of a project. When this data is initially added, I have an automation that copies it to another sheet used by another department. I need to add a formula to the other department's sheet that will update a…
-
Is it possible for multiple column links, formulas, and manual data to all exist in one destination column?
Can a single destination column support multiple column links coming from different source sheets to populate different rows within the column, as well as allow formulas or manual data entry in other rows in that same column? I have different sheets (A, B, C) where teams document their capacity month to month. Each month…
-
Lagging Formula Calculation
Hi all, Question: What makes cell formula update/populate a value and why would there be a long delay? Here's my issue: I noticed a request was stuck in my workflow, and when I reviewed the cell history on the helper columns I noticed the culprit was a cell with a relatively simple formula that didn't populate a result…
-
Does Smartsheet have an equivalent to Excel's RAND() function?
Hi, I'm trying to determine whether Smartsheet has a feature similar to a heat map, where cell colors automatically adjust based on changing values across a column. Since the values are constantly changing, using fixed conditional formatting ranges isn't practical. Is there a way to color cells relative to the column…
-
IF TODAY function
Hi All i am trying to determine the stage that a project should have readhed by today, based on a series of milestone dates across the row however, in this particular example i am getting #invalid operation which may be due to the blanks. they are blanks because they currently have no date which is probably a flaw in the…
-
Automation -Approval routing auto declined once approver open the email notification for approval
that is my automation workflow Scenario is for example - user submitted the request for approval there are tier of approvals ; capping amount 0-99,999.00 after RA lead approved the sewhich approval is director of treasury then for the amount 100k and above approval goes to COO but in this once automation sent to the…
-
Automation -Approval routing auto declined once approver open the email notification for approval
that is my automation workflow Scenario is for example - user submitted the request for approval there are tier of approvals ; capping amount 0-99,999.00 after RA lead approved the sewhich approval is director of treasury then for the amount 100k and above approval goes to COO but in this once automation sent to the…
-
Modified SUCCESSORS() function to report more than just direct successors
WHY IS THIS USEFUL? This updated function would allow us to filter the spreadsheet for only the driving path to a particular row#. This would be similar to a filter for critical path, but enable much more flexibility. Current status: I've successfully generated a "Successors" column, listing direct successors of each row,…