- 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…
- IF statement
I am working on a sheet and want to incorporate an IF (or maybe an IF AND) statement based on the date items are submitted to them for review, which is one of the date columns in the sheet. Here are the conditions I want to test: 1) If today is less than or equal to 3 weeks from the submission date, turn the RYG ball…
- Hiding Completed tasks
我用smartsheet to track projects and their coresponding action items. After tasks are completed, I want to be able hide the rows to make the smartsheet easier to navigate. Is it possible to hide rows? I can't tfind the functionality. Any help would be appreciated.
- Smartsheet forms are still not WCAG complaint :(
I found that Smartsheet forms fail WCAG compliance using the WAVE tool due to the logo image lacking an alt-tag. In April, I asked about adding alt tags without success. Failing WCAG is a deal breaker for my organization. Is there any plan to add alt tags to the logos on forms?
