-
Automate sending an email referencing a column
I have a form where the public submits information for a schedule change. Can I set up a workflow so when I mark 'complete' in a column, I can reference the column where the email is located to send out an auto response that their request has been completed? These are non-smartsheet users who do not need any access to the…
-
Auto-populating form fields
I'm working on a form right now and am having some issues that I'm hoping someone can help me with. I'm trying to develop a form that auto-populates specific fields. Something similar to the "request an update" feature, but in a form that I can edit the look and layout of. I've tried using a query string, but so far I…
-
Automate RYG Balls based on % complete and start and end dates
I would like to have the RYG balls automatically adjust based on the percent complete and start and end date. For instance, if my task is set to start on 10/2/17 and end 10/13/17, if my % complete is less than 50% by midway between the two dates, to turn yellow. If my % complete is less than or equal to 90% by the end date…
-
Resource Views by Project
I am having numerous challenges with the Resource Views and not finding them particularly useful. I only want to see resources for particular sheets, my preference would be to select a workspace that contains all the sheets but as this is not available I am selecting all the sheets individually, however, I am still getting…
-
Smartsheet Trivia
I just got back from the Engage Conference (which was AWESOME) and I decided to make my team work for some of the swag I brought back for them (including the LAIRD Water bottle). I thought it would be fun to have a Smartsheet Quiz.... Trivia or How would you? type questions.. I'd love your ideas for questions to…
-
COUNTIFS formula with multiple criteria
Hello, I've been having trouble with a formula to find out if new instructors (I also have returning instructors on the spreadsheet) attended a conference. Here are the details. I want to count column 6 "attended conference" when checked, only if column 3 "new instructor" is also checked. I've tried several variations but…
-
Checking Done for multiple cells
Hi! I am trying to find a formula to check a box Done when several other cells are checked done. Such as Master Task=done when Task 1, Task 2, Task 3 and Task 4 are checked done. My If Then formula doesn't seem to work. Any thoughts? =IF([Column2]1 = "Done", 1, 0)
-
Master Sheet with Subprojects Inside
Hi! I am trying to create a Master Project sheet that would include subprojects inside of the same sheet. Basically so I can track the dates and overlapping of tasks in the subprojects. Is this something that Smartsheets can do? I know I can do it in MS Project and just add each subproject as it's own task in a master…
-
New Dashboard Widgets
Hi ... in reviewing some of the youtube videos I noticed some different dashboard charts. How can we add or get access to other chart types than what is available in Smartsheets today? Thanks Jeff
-
Priority Rating with Formula Logic
New to smartsheets and the Formula and I am basically trying to set up a priority rating system. There are 4 priorities and 4 questions. If all questions are answered yes and the one checkbox is check then it gets a rating of P1 but if 2/3 questions are yes and the checkbox is checked then its p2 and so on and so on. I am…
