-
ISCRITICAL for Parent Tasks
Currently, Critical Path does not propagate from a Child to the Parent Row. Create a functionality or a new formula for ISCRITICAL to show on Parent Tasks, maybe even up through a specified number of levels in a hierarchy.
-
Hours and Minutes calculation
Hi, I have a Start Time column and an End Time column and I would like it to calculate the hours and minutes of duration into another column. I scoured Smartsheets and found information on this, see link below, but when I try the formula, which should give me 0 hour(s) and 45 min, I get 0 hour(s) and 4500 min. Can someone…
-
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…