-
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.…
-
Dashboard vs Master Calendar vs Sights ?
Hi Trying to step away from excel, I am fairly new at using smartsheet and am looking for the best way to view simultaneously multiple sheet to better manage the deadlines of our projects. Being an expeditor, dates are the driving factor to help me guide the multi-disciplinary teams. Since we have multiple deadlines…
-
clock icon in iOS app
We are trying to use the Smartsheet app for the iphone. One of the users is not being able to update in the list view and seeing the clock incon next to each line item. Does anyone know what this means? Thanks for your help.
-
Field Employee time tracking software that integrates with Smartsheet?
I'm looking for a time tracking solution for field employees that integrates with Smartsheet. In our organization we have a master project list sheet that compiles project data for all of our active projects. Our field installers are currently logging their time using T Sheets, they're clocking in/out as well as selecting…
