-
Importing\Uploading Information
I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will continue to be used, and import it into SmartSheet, then you want to update the information in the SS later by just…
-
Automate RYG Balls based on % complete and start and end dates
I would like to have the RYG balls automatically adjust based on the percent complete and start and end date. For instance, if my task is set to start on 10/2/17 and end 10/13/17, if my % complete is less than 50% by midway between the two dates, to turn yellow. If my % complete is less than or equal to 90% by the end date…
-
Formula Confusion!
We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated! We have a main sheet with all our orders on it, using an older version to muck about with layout at set up at this stage hence the old haulage dates! Each order has details of the sizes…
-
Sharing an alternative email address
I usually "recycle" email addreses to avoid license payments. For example: normalemail@test.com and the recycled one would be, normalemail+alt@test.com Gmail allow that, and it eases some automatic activities. Anyways, when I am trying to share a sheet in smartsheets, the system does not allow to do that, and alerts that…
-
Recording the date of a specific update and locking that date?
Greetings SMARTsheeters... Not sure if what I'd like to do is possible in SMARTsheet, but here goes... I'm working on a SMARTsheet that receives data adds and modifications from SMARTforms and autoupdate email requests. There will be various users entering and modifying the data in the SMARTsheet adhoc through these forms…
-
Actual % Complete Formula?
I'm trying to answer some questions on why the Project % Complete values are what they are, in greater detail than what is provided in this help article (which just indicates that it is calculated by Smartsheet based on Duration and % complete of child rows). Does anyone know what the actual formula/process is that…
-
COUNTIFS formula with year
I'm trying to put together a COUNTIFS formula for my Sheet Summary that will count the number of items that are shown as Completed in the status column along with what year they were completed in. Looking at other discussions, I found this: =COUNTIFS([NVAP Phase/Status]:[NVAP Phase/Status], "Completed", [NVAP Completed…
-
Report Builder Problems
With the recent (Sept 19, 2019) update, non-licensed users no longer have the ability to update their Report Builder within SmartSheet. This poses a significant problem for my company, as we have multiple licensed users and ~100 (non-licensed) individuals who execute the tasks assigned. Am I correct in thinking that each…
-
Editing Chart Widget
I am using a pre-built template dashboard and am trying to see the data that the chart widget is referencing which is displaying on the dashboard but am unable to determine what data is being used.
-
URL for a Web Form
I have to publish the Web form link on SharePoint for internal staff to access, fill & submit their requests. If there are any changes in Web Form in future will original URL work? or it will change after changes done in the web form?