-
Drop down list central location?
Is there a way to have a drop down list used across multiple sheets refer to a centralized location for the list? That way if the list needs to change, it can be changed in one place and seen everywhere it is used.
-
Proposal for alternative views in resource view
We are keen users of smartsheet to track project plans for all our projects. Having a very dynamic operation, we have a general list to allocate non-project specific tasks on a weekly basis. This means that some tasks/activities are planned on a monthly basis ( e.g. assining one person 40% to a project). Since we plan…
-
Is it Possible to See My Update Requests Across All Sheets?
My team and I have a lot of projects going on simultaneously. I send them update requests on a regular basis, but I can't seem to find a way to see all of my pending requests at once. For example, if I'm meeting with a Project Manager, he or she may have 10 to 15 different projects going on.... It would be great if I could…
-
How do you set Alerts based upon field values?
Desired Result: An Alert email is sent to the user name specified in the Contact List column when the status on that row equals a certain value. Example Layout: Column A is a Contact List drop-down Column B is a Status drop-down with labels of Planning, Contract Request, Complete Columns C - Z are various data fields…
-
How To View Projects To Which I Am Allocated
Is there a way to see all of the projects to which I am allocated? In Resource Views, I can see that a resource is allocated a certain % to 'Other Sheets' but cannot tell which ones as they have not been shared. I'd like to have these resources tell me which 'Other Sheets' they are allocated to so that the allocations can…
-
Apply formulas to data aggregated in a report
So we've just started using smartsheet to track hours used for different projects. Each person gets one individual sheet to fill in. Once a week a report extracting the hours from the last 7 days is extracted and sent to the people keeping track of the mother organization. However, as a manager I'd like to keep track of…
-
Multiple discussion for one row - MISSING
Hi, Since the last update it is not possible to make more than one discussion per line. Please make this undone. I'am really unhappy! Best regards
-
Problem with Formula when inserting a row
I'm not sure how to handle the following situation... my data looks as follows: The formula in Status2 (and filled down) reads as follows: =IF([Act Finish Date]2 = "", "Open", IF(AND([Act Finish Date]3 = "", [Act Finish Date]2 <> ""), "Closed, Last Event", "Closed")) In other words, the formula is checking not only if a…
-
Feature Request - Sort/filter by History
OK, so there are many useful applications for being able to sort rows by the history of the cell. In one way this is possible if you have the 'date modified' column in your sheet, but this only shows that something in the row was modified. If you have multiple columns, this requires you to check the cells for which changed…
-
Microsoft PowerBI
Hi All, I just started using the data connector for Power BI and it is pretty slick. The one problem I'm having is that in smartsheet columns are formatted as text/number but can't be defined as a number only, power BI does not recognize these fields as numeric so it can't perform additional calculations on the data such…
