-
Is there a way to update referenced sheets using vlookup and/or index and match?
Hi there, We have an issue where we provision a project from our intake sheet, but after it hits the project roll up sheet, we can't update the status. Here's a summary of how our workflow: Intake listing sheet - has our projects intake, which eventually end up as an "approved project". Each initiative has a unique ID…
-
Calculating time elapsed date and time
Hi all, I've read a few solutions on how to do this but just can't get my head around to apply it to my own sheet. I have an incident register that we are moving into smartsheet and one of the columns is duration of outage. In excel we have two columns; Incident start date + time and Incident end date + time (format…
-
Smart Sheet Summary for average time between two dates for two columns
Hi all, I am having some issues working this one out and am hoping someone might be able to help! I have two columns in my sheet that I am interested in, "Predicted UAT Start Date" and "Actual UAT Start Date". I then have many rows for each of our different projects. What I would like to know is the average amount of time…
-
COUNTM for 2 Ranges
Hi, How can I count a total of values, in 2 diferent columns that are in 2 deiferent sheets? I need something like this.. =COUNTM({Range 1} AND({Range 2}) Thank you!
-
lookup in smartsheet within a zapier flow
Does anyone know how to do a lookup in smartsheet within a Zapier flow? Something similar to a Google Sheet lookup functionality?
-
Pulling out data from a master sheet
Hi all, I'm in need of a solution to track activities. There is a master sheet that I have view access to where items get added by different parties. I want to pull out data based on a filter to create a tracking tool to make sure that my tasks in relation to the tasks in the master sheet are completed. Think about…
-
Setting different working days for individuals
Is there a way to set different working days for individuals? I know that it is possible to define working days through the Project Settings function but I want to set this for one person only to reflect their part time working structure - is this possible? Any advice would be gratefully received. Thanks
-
Excluding duplicates from formula
Hi there! Had a wonderful talk with a Pro Support the other day, and he helped me write an incredible formula for counting "Left to Sell" value on sales items our team is selling. However, I noticed after the fact that it is counting each item as 1 sale, and there may be some sales that cover multiple items but should only…
-
How to edit a workspace
I have been given "Editor-cannot share" permissions by the owner of a workspace but I am unable to make any edits in the shared workspace. When I try to double click on an empty cell, I do not get to edit it. Please advise.
-
Behavior of "=" Operator
On several occasions I have confused myself, not understand why I am getting a #NO MATCH error when comparing a Text/Number column to a Auto-Number column, and I have realized why... Results in False 001 = 001 099 = 099 Results in True 100 = 100 10000 = 10000 I understand why this is happening, but I do not necessarily…
