-
Trouble gathering a SUM from another sheet.
I've been running into an issue where I have a sheet that gathers all information from a form. Im trying to gather a sum of a total of a column, but only reference the values of specific rows that from column. Example: I have Column to indicate "fixture color" that will be a specified by the form. I want to sum another…
-
Calculate time between start and stop
Hello - I thought this would be an easy formula but it keeps returning at invalid or unparsaeble. I am trying to find the difference between stop time and start time - when I enter the Stop time on line 25 (2:44) and then I enter the next start time on line 26 (6:33), it automatically calculated "Time Between Cycles" as…
-
Any Ideas or feedback?
Hello Looking for ideas on automation solution and hoping someone here can help. Scenario: My utilizes Smartsheet as Workforce Management System. We support a contact center of around 1k agents. The various sheets\reports\dynamic vie\ automations that have built cover the full gambit of a WFM system including a roster,…
-
#Circular Reference
I am trying to create a workflow where if the "Pull Date" cell is in the next 14 days, the value in the Status column changes to "Upcoming". The workflow did not work. So, Smartsheet AI suggested formula =IF([Pull Date]@row <= TODAY() + 14, "Upcoming", Status@row ). I put this formula in the Status cell and get #Circular…
-
[Need Help] Lookup/Index matching for Horizontal Data
I’m trying to automatically assign a reviewer type (like “Peer” or “Leader”) based on a reviewer’s phone number. The problem is that in my reference sheet, the 20 possible reviewers are listed across columns — each one has a phone number and a reviewer type in a separate column. In my submission sheet, I just have one…
-
Referencing an imported sheet
My workflow requires me to update a big chunk of data every week. It's about 7500 lines so I cannot copy-paste it, I can only import it from excel. Once the data is in smartsheet, I use vlookup to reference the values of specific columns in another sheet. The issue is that each import creates a new file so my vlookup…
-
Populate Quarter based upon date
I would like to populate a field called Quarter based upon Week Start Date field. All I need in the Quarter field is Q1, for example. Q1 = Jan - March Q2 = April - June Q3 = July - Sept Q4 = Oct - Dec I have tried to figure out the formula, but haven't been successful. I have manually been adding the information into the…
-
Adding Current Month Data To Dashboard and Metric Widgets
Hello Community, 1st Question: I am creating a dashboard for our compliance statistics. I have built out a dashboard calculation sheet based off other sheets as seen in the image below. I am looking to add only the current months lable and associated data to my dashboard to keep it clean. 2nd Question: I also have the…
-
Search and find the last sequential duplicate key in a Smartsheet?
I have a target sheet that has duplicate keys where the keys/rows can be found throughout the Smartsheet. I need to display the column named 2501_January value from the last sequential key's row in the target sheet. In this example, I want to search and find the last Row Key Rev-2 at the bottom of the Smartsheet from my…
-
Formula to search across multiple contact column
Hi, we are using the following formula, but it only works for calls with a single contact per cell, even though is looking into multiple contacts per cell. We managed to fix this by using a helper column that's the same as the contact column but set as text property. Is there a way to make the formula work with the…