Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
i have 2 sheets to reference
first sheet has a confirmed check box column
but on another sheet i want it to check a box as a pilot user if the confirmed was checked...
is there a way to do this with a formula?
Hi,
The simplest way would be to use cell-linking and link the checkboxes.
Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I have an Action Log and in the log we have a column that identifies the different projects our team leads. There is also a Workstream column, which identifies what workstream is responsible for getting the answer. There can be more than one answer, so we have a dropdown and if multiple workstreams are responsible for the…
So here what I'm trying, I have multiple solution and status for all. Trying to get the total net worth value of order based on solution + individual status. Let's say I want to capture the total revenue for Centralised Inventory with all different status as below: I tried with Sumifs but it's not calculating all values.…
I would love some help troubleshooting a column link issue between two sheets used for department metric scorecards. Sheet 1 (source sheet) is the metric submission sheet where metric owners report quarterly data. Sheet 2 (target sheet) is the scorecard that shows quarterly goals and actuals, with a status symbol for each…
