-
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,…
-
Formatted Dates and Text
Hi everyone! I have a list of report dates that I want to be notified on, but am having trouble getting this set up. My thought process was to create a column with =TODAY() in the first cell, and then set up automations to be alerted when "Today" equals the "Report Date". My issue is that two are different formats. The…
-
Best practice for cross-team project dependencies and consolidating reporting?
Hi everyone, I am looking for advice on the best way to architect a cross-team project tracking system. My current setup: I have multiple teams, each maintaining their own individual project sheet. Each sheet contains a list of projects specific to that team. The Goal: Cross-team Dependencies: I want to add a dropdown…