-
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?
-
color foreground formatting
Hey, I'm playing with the text colors via the api, do the color values corespond to some system? I've been random guessing without being able to get the right one.
-
Web Forms in Tabular format.
Dear, There is any way to create webform using the actual spreadsheet? I would like to have similar functionality to the webform that smartsheet sheet but in tabular format. For example, everytime a person would click on the link to access the form, they will have blank new spredsheet to fill out just with the column…
-
Planned and Earned Value into Project
Wondering if anyone has done any formulas for either Planned Value (PV), Earned Value (EV), into their SS projects? I have all the costing,tasks, opex/capex.%Complete,dates.. in my projects and this would be my next step :)
-
Trying to change RYG based on status of a group of rows and Subtasks
so i have rows that turn red green or yellow based on progress i would like a master progress since the rows are normmaly collaped that shows over all status of a section i have code but its not working =IF(COUNTIF(Status18:Status25) = 0, "Red", IF(COUNTIF(Status18:Status25) = 100, "Green" , IF(COUNTIF(Status18:Status25) <…
-
Sheet with Database Normalization (Primary and Foreign Keys)
Can I upvote for Database Normalization? Many colleagues and I are using Smartsheet daily and are starting to implement it company-wide. One thing we'd like to do with it is use like a database. That said, it would be great if there's some capability of assigning primary and foreign keys.
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
