-
Teams Integration
Hi All, I have been tasked by my manager to incorporate SmartSheet into Teams. We have completed the integration and I can now see the shared sheets in Teams without issue. We would like to go a step further and be able to receive notifications in Teams when certain fields are completed on the Sheet. Is this possible?…
-
How to retrieve an error file
I made heavy traffic of cell links with other sheet and it was error on my sheet. I could not open the sheet. How to retrieve the file?
-
RYGGrey ball formulas for multiple columns (beginner)
I am trying to automate the RYGGrey ball status column, based on two date columns ([Start] and [Finish]) and 2 check columns ([Task Started] and [Task Completed]). Having trouble getting started and follow the right syntax. Here are my conditions I am trying to meet. TIA for your help. Grey * If TODAY < [Start] and [Task…
-
Sum up rows within the VLOOKUP formula
Hi everyone! I have several projects in my time tracking sheet and would like to use the VLOOKUP formula to save only the times per project in a monthly cost table. For that I used the following formula: =VLOOKUP([Project Number]12, {Sheet - Time Tracker (10-October) Range 1}, 8, false). Unfortunately, I only got one labor…
-
Nested IF Statement
I'm fairly new to Smartsheet and I'm trying to calculate a planned budget based on an "Assigned to" column. I'm getting unparseable, so I'm missing something. Here is what I'm trying to build if someone might help me solve the issue... =IF([Assigned To]@row = "Bob Dole", [Planned Hr]@row * 175), IF([Assigned To]@row = "Abe…
-
Receiving "Invalid URL" When Attempting to Link Into a Share Drive Folder
I've scoured the interweb trying to figure out how to link from my Smartsheet into a share folder using an html link, and have tried several different methods, but keep getting this error message whenver I try. Any suggestions?
-
Resource Allocations based on Capacity
I am trying to figure a way to do resource allocation based on the number of projects a particular sub can handle at one time. We have 20-30 projects next year and trying to award bids based on capacity of the subcontractor. For example, one electrician maybe able to handle 3 projects at a time vs another who can only…
-
How identify where actual lag time is different from standard lag time?
Need a way to identify tasks on my workplan where the actual lag time is different from the standard lag time. My workplan includes: 1. Predecessor column (includes predecessor with +/- lag) 2. A separate text column "Standard Lag Time " Whenever the lag time needs to be changed the predecessor column is updated. The…
-
#NO MATCH when counting the results of a VLOOKUP
I am trying to count how many items fit 2 criteria, one is the year, the other is the state. The issue is coming in with the state, as I just changed it to a VLOOKUP and my formulas were all working before I did that. The VLOOKUP is working, but there are a few values which return a #NO MATCH and I can't change that due to…
-
Feature Request: timestamp() function
It would be great if there was a way to timestamp the value of a cell. To enter the exact date that an event occurred. Several people have volunteered a modified date column, but something like the following functionality in an if-statement would be really great. =IF(FieldName1 = "blah", timestamp())
