-
New to Formulas - Need help with Text Answers
I have tried to create a formula using three options being 1. Does not meet Insurance Standards, 2. Meet Insurance Standards 3. Exceeds Insurance Standards for a particular series of questions. If you choose "Does not Meet Insurance Standards" then then next column Score will also populate 1 and the cell will highlight…
-
Missing smartsheet template
When Smartsheets launched thier new card view, they also had several templates they provided. I downloaded one that was a ticketing system that tracked average submissions per day, etc. I cannot locate it now. It had some fairly complex formulas that made the tracking work. I have attached a screenshot. Anyone notice this…
-
Ticket Tracker Notifications
We would like to have Ticket Tracker send an email to the person who submitted the ticket to us, when that ticket has been "resolved". I do not want everyone to get the notice, only this one person. Has anyone been able to do this? I can set the Alerts but cannot narrow it down to just the one person. I can do a reminder,…
-
Setting up a Point of sale Sheet
Good afternoon, I was thinking of setting up a POS/point of sale sheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc.. Then it came to mind that I should check here. I did speak with…
-
Date Driven row roll off
We keep a list of Completed tasks. Based on the date in the Work_Ended column, I would like to autmomatically move rows > 90 days old onto another sheet, which we'll call Completed Archive. Is there any way to automate this process? Thank you!
-
How to populate % Complete from another Text/Number column that has a formula
Hi, I'm trying to calculate and populate % Complete automatically using check boxes fields. For example I have 3 check boxes for 3 main activities per record. So I created I new field Count Check Text/Number field where I check if the first check box is checked the new count is 33%, if the second is checked with the first…
-
Resourcing Allocations
I am trying to find a way to accurately reflect the resource capacity of an individual when assign multiple concurrent tasks in a single day. I appears that if I assign for example 8 one hour tasks (effort = 1h) that the person shows up at 800% capacity for that day rather than being at 100%. How can I make this work? Do I…
-
Error in creating new Smartsheet from Google Drive
Anyone see this or know how to get around this? I could not find anything related to this problem. I have successfully installed the Smartsheet app to Chrome from the Chrome Web Store. I do New->More->Smartsheet. I get past the "Your domain administrator has approved access to Smartsheet" . Then, I see the error message,…
-
Smartsheet App for Outlook desktop installation
Is there an installation available for the Smartsheet App for Outlook 2013 desktop? Basically looking for an .exe or .msi that can be used to install the add-in for Outlook. The installation from the Microsoft App Store doesn't work for my account. I have a corporate Office 365 account and my email address matches the one…
-
SmartSheet charting
Is SmartSheet looking into making Excel type chart/graph creation available either within sheets or as an addon?