-
Recurring Reminders for the same Row/Action
Hello, I have a row/action that I would like to set an automated weekly reminder. I currently go in weekly to manually put in the reminder. Is there a way to automate this so I get a reminder on this task every Monday (at 2PM)? Michelle Rojas
-
Stacked Bar Chart
I am attempting to create a bar chart widget that summaries hours by department on a given project, but I can't seem to figure out how to get it to display the information I need it to. I have the data set up in a sheet as follows: I would like the graph to show each department's hours as a portion/percentage of the total…
-
Workflow Question - Decline with An Attachment
Wondering if anybody encountered the same situation here. I have a very simple mechanical drawing approval workflow that works fine if the approver only click on "Approve" or "Decline" button. The approval column will change to Submitted when drawing submitted (trigger by attachment), and changed to Approved or…
-
COUNTIFS from multi-select drop down
Hi Community, hope you are well! I would really appreciate some help with the following formula. In a master metric sheet I would like to count multiple criteria. I am using this formula which works great since it is automated once the @row are filled in by my Team: =COUNTIFS({Planning sheet Range 2}, PA@row, {Planning…
-
Version Control of Project Plans/Sheets?
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, so we need to amend it. Since there seems to be no way in Smartsheet to baseline the…
-
Has anyone attended the Project Management Track from the Learning Center
Are they worth the price tag? can I get this info watching Youtube videos for free?
-
Designate Holidays for Multiple Years
Hello, I am wondering if there is a way to automate/semi-automate adding holidays to project settings. For example, is there a way to indicate 12/25 will be a holiday regardless of the year, so that as time goes on new Sheets will always take into account standard holidays? Thank you, Dan
-
Index Match Formula with Multiple Criteria?
Hello, I'm trying to create an index that has multiple criteria. I'm not sure if I should do this using an "IF" formula, or if I need to incorporate the "AND" function into the formula. Or if I need to go in another direction to accomplish this. What I need to do is return the "Rate" based on the "Crew Type", and the…
-
Checkbox Formula for entire Column
I am currently using something similar to the below to translate checkboxes to values, and am then concatenating those values: =IF([Test 2]1 = 1, "Test 2:", " off ") The problem I am running into is as new rows are made, the formula is not auto-populating the cells. does anyone know how to incorporate the above example,…
-
Record a Date Action for Automated Workflows
I've noticed a few posts on Community re: the release of a new workflow action - Record a Date. I'm not (yet) a member of the "Social Groups" Community so I'm unable to read the full text of each post. In addition, a Smartsheet Partner @Debbie Sawyer made reference to the new workflow action in her answer to…
