-
Finding a value from one sheet on another sheet and transferring cell info onto both
I need help figuring out a formula that will cross reference between two sheets. I have one sheet that stores our open orders and another that tracks our orders undergoing quality assurance. What I need is a formula that takes the order number from the open order sheet and searches for it on the quality assurance sheet,…
-
Smartsheet Automation: Copy and Move Rows Limits
Hello all, this might be long winded, so apologies!!! My situation: I have a Smartsheet currently that holds all information for the current FY24 - Lets call it Sheet A. Coming in October, this information needs to archived off of this sheet to lets say sheet B so then Sheet A is blank and can intake FY25 information. I…
-
How to write COUNTIFS with a NOT element
I have a working formula for looking up an external reference sheet. All the external fields are tagged with an M: =COUNTIFS({ReportM}, "Jul 24 - Oct 24", {ProjectM}, Metric@row) but I now need to exclude a third criterion {ThemeM}, "History" I tried adding it as =COUNTIFS({ReportM}, "Jul 24 - Oct 24", {ProjectM},…
-
Sum(Collect Calculation giving #Circular Reference Error
=SUM(COLLECT({Forecast Amount}, {Customer}, $Label@row, {Sales Stage}, Qualification$1)) That is the calculation I am using bring forecast sales based on Customer and Sales Stage into a metrics collection sheet. I am going out to the Sales Pipeline sheet for the information, two (2) sheet prints attached for reference.…
-
Formula to mark the checkbox for the newest date in a row
I have two columns in a form: Current Status and Date of Completion. The Date of Completion column should be updated on a weekly basis. I want the Current Status to check off based on the latest Date of Completion. Is there a formula to do this?
-
Need Help with Auto-Generating Project IDs in CopyRow Automation
Hello Everyone, I'm looking for some advice on automating Project ID generation in our CopyRow Automation process. My department uses this tool for project intake when sending work between teams. However, we need to include a unique Project ID that transfers to the destination sheets. Currently, our project managers spend…
-
I would like to trigger a workflow based on a store opening date
So for example a new store is opening on 7 October. 30 days in advance the workflow needs to kick-off, based on the Opening date, I would like to write a formula that auto-populates the start date. This will allow me to notify people and a workflow to start. Not sure what formula to us.
-
Smartsheet Summary Counting Assigned to with multiple people in the field.
I have the sheet below and I want to count for each person how may items are pending their approval. The formulas I have tried only find where it is only one person in the column. Where there are two people in the column it ignores the column. I have tried =COUNTIFS([Pending Approval From]:[Pending Approval From],…
-
Create Formula in Sheet Summary field to pull only Month from another Sheet Summary Date Field
I have a date field for projected go live date for projects in my Sheet Summary. I would like to add another field with a formula that will display only the Month Name in another field so that when I run the Sheet Summary report I can summarize projects going live by month. I would appreciate any guidance!! Thank you!
-
How to number the duplicate by Sequence or Order?
Hello there! I need help on finding duplicate values to my table and then put them in sequence or Order. Thanks in advance.