-
Dynamic Allocation % / Resource Management
Monitoring RM (Resource Management) is pointless if the data is inaccurate! Current “Allocation %” is static (if RM is enabled) making RM data inaccurate! Please LIKE or bump if you agree that we deserve a truly SmartSheet w dynamic content! “Allocation %” should be able to accept a formula. Currently when you turn on RM…
-
Filtering with Start and End date views
I have filters setup to view different tasks on separate calendars. However it only shows the StartDate. Is there a way to enable EndDate as well?
-
formula for date to land on the following Tuesday
Hello, I am calculating a date based on another date: =[Proof to LSI]70 + 49 I would like to add to this formula so that the date will always land on the following Tuesday. Any suggestions? Thanks, Kim
-
=IF formula ???
I am trying to create an alert formula. I need to contact people every 15 days. I have one cell that states "Last contact" and the date, another that states "Next contact"and the date, the third cell, I would like it to state "Contact" in red. Can anyone help me formulate the "Contact" cell?
-
autofill linked cells
I have a Master sheet with job rows that number 1to17, next job starts on 18 and are the same rows of data. These continue as such for subsequent rows. My other sheets link to certain rows on this Master. For example row 17 is always "Shipdate", so my "ShipDate" sheet links to row 17 on each job so I can have a calendar…
-
Shared reports are blank
Hello, After performing a search I ran across many others users running into shared reports showing up as blank pages. I tried the solution I ran across and assured that the user also had access to the sheet the report was made from. And still I am seeing a blank report. Was this ever corrected in early/mid 2016? I am…
-
Filter Cards by Phase/Title of Parent
Is there a way in the Card View to filter and only see cards within a certain phase or cards that have the same 'Title of Parent'? I have a multi-phase project with hundreds of total lines and it would be great to be able to break up the cards to only focus on the current phase of the project. I'm also open to any other…
-
Setting conditions for RYG balls
I would like to have the RYG balls automatically adjust based on another status column. For instance, if my outside sales people set the status of a row from bidding to the following: Status "Lost" = RED Status "Postponed" or "Unknown" = YELLOW Status "Won" or "Obtained" or "Negotiating" = GREEN Status "Bidding" =Will…
-
Smartsheet for Social Media Client Approvals
Is anyone out there using smartsheet for social media management and client approvals? We are dealing with a high volume social media content calendar that requires client approval on social media copy and any design work. The process touches multiple persons throughout the process and we have an extremely difficult time…
-
Contact list and webforms
Hi, I have a column on my sheet which is the contact list. However, in the webform it does not show as a contact list. So I had to go and make it a dropdown with the exact same options as the contact list. Now, these sheet line items are not pulling through on my various reports. Because in the report builder I must now…
