-
Update Request Form
Hi, I am wondering if there is a reason why my update request will not let the user update % Complete. Does anyone have any insight to why it will only allow certain things to be updated? The way the Request is set up is: "On 03/04/19 at 11am In any row where % Complete is less than 100% and Start Date is in the past Send…
-
Smartsheet Excellence - worth it?
Looking into either Smartsheet's excellence training or another bigger picture project management training. Does Smartsheet's excellence courses provide value beyond just the Smartsheet tool? Basically, I'd prefer something I can grow my project management training that doesn't tie me to a specific tool (even though we'll…
-
Copy Rows Between Sheets Based on Checkbox
I am trying to create a calendar or events based off a master list of events on another sheet. The source sheet is a master list of all possible events. That sheet contains a column of check boxes. When a checkbox is checked I would like it to automatically copy that row from the source sheet to the destination sheet. The…
-
Formula for auto flag
I am trying to create an auto flag on a project that says if % complete is <= 80% and the end date is <= 7 days from today then flag. Here is what I have so far =if([% complete]<=0.8,0.5,0)+if([end date] - today()<=7,0.5.0). It turns the flag red when it falls into the not 80% complete in the time frame but when there…
-
Sumifs with Date Range
Hi there! I'm using Smartsheet to keep track of timelines and allocated ressources called FTEs across multiple projects. I'm trying to figure otut a way using the SUMIFS formula to sum up the usage of FTEs across all projects per month. Currently, I'm using =SUMIFS(FTE:FTE; Projekt:Projekt; "Project A"; Start:Start;…
-
How to group sales by representatives in a report?
Hello Smartsheet community! I have a sales sheet where new sales are added each day mentioning the amount and the representative. the sheet doesn't use contact list for representatives, just a simple drop down menu. I want to add a widget to our dashboard showing total sales by representative. I made a report by selecting…
-
Resending Update Requests?
I'd like to be able to resend a pending update request as a reminder to my user. It doesn't appear that I am able to do this. I can view the request. I can delete it. But it doesn't appear that I can "resend it". That said, the "Edit" menu option is greyed out for me when I look at a pending request. Anyone have any…
-
Recurring / repeating tasks & time
I know this has been requested before, so I'm recurring / repeating this request lol. I know you can use formulas but it's a workaround with limitations. Right now I have to use my Outlook calendar for recurring tasks which prevents me from using the Smartsheet calendar which leaves me managing tasks using both Smartsheet…
-
Calculating a staged reduction in severity
I have one column that shows what a risk is ranked as (a score from 1 to 49 with 49 being the most risky). I am trying to put in another column that lets a ranking for the effectiveness of the mitigation planning (score of 1-5) and then have that drive an auto-calculation of the final score of the Risk. Unfortunately I am…
-
Formula Sumif Range w. Web Form
I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, Task5, Hours2:Hours4) New Webform entry is line 5, Formula will not automatically capture that added line. Please help.…