Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for March 2016
Discussion List
Calendar showing 'edit smartsheet rows'
Is there a way to stop the iCal showing 'edit smartsheet rows' on every item? We already have so many shared calendars, this is essentially doubling up on items for no reason...
Webforms: Auto hide based on answer of other field; Alerts based on answer of field
HI, I have a few questions. Scenario: A team fills out a webform every time that a they take a call. There are different fields available to them to fill in. Some of these fields(especially towards the bottom) do not apply if one of the first fields they fill out are filled out with a specific answer. each of these fields…
How can I see a dashboard of all my projects - from Home Page?
Is there dashboard view for all my projects? Something that launches as Home Page?
Can I build a resource pool to choose from for multiple projects?
Is there a way to build a data base of human resources (assigned to) that I could choose from when working within multiple projects? Is there a way to indicated allocation % of that resource so I can understand if certain resources are being over-allocated or under-allocated?
Using Alert Feature
Hi- Is there any way to have an alert when something is added to sheet, not changed. Nonetheless, i am trying to use this feature but i have not recieved any emails "alerts" stating that i have changed something.
Excel template that generates (automatically) formulas for smartsheet
Hi Guys, I made an excel (macro enabled) that allows to my team create projects easily and faster. The file generates (automatically) formulas for smartsheet. I publish the example here You can register time here This is the video The video is in spanish, I will translate it in the coming days. Regards, Álvaro
Microsoft Project Import Settings
Hi guys, I have a client who needs to view an export from smart sheet in MS Project. It's quite a large plan of 1000+ lines, and whenever I import either the XML or Excel file from smart sheet into Microsoft Project (have tried versions 2010 and 2016), the dates are changed Microsoft Project. I believe this is because…
Restrict input to only values of drop-down list
I have a sheet with a column that I've defined as a Dropdown List with a set of values. However, it seems like Smartsheet still allows other values to be manually typed into the cell. Is there any way to restrict input to only those values defined in the drop-down list?
Using SUMIF when column is not blank
Hello, I am trying to sum only the values of the children in one column for which the corresponding cell from another column is not blank. I tried this formula: =SUMIFS(CHILDREN(Amount25)), (CHILDREN([Date Paid]25), NOT BLANK), but it did not work. Is it even possible? Thanks!
transfer rows form 1 sheet to another
Is it possible to add a micro that will automatically send rows from 1 sheet to another once a completion date in a colum has been reached?