-
% Completed and Task Finished
I would like to have the % completed set automatically to 100% when the Task Finished is checked. Any suggestion on how to do that? First smartsheet struggles...
-
Multiple selections
Is there a way to create a multiple selection option in a column? Was considering Checkboxes that could be linked to the selection by typing next to it or drop down options with ability to select multiple choices? Please let me know if anyone has created something like this or if there is an option to do something like…
-
Auto-fill form/cells when a certain item is selected from a drop-down
I was wondering if it is possible to auto-fill cells based on an item that is selected from a drop-down. I am trying to create a form for our subcontractors to upload submittals and I wanted them to be able to select from a drop down list what they are submitting. I.E. Product Data for Paint, or Samples for flooring. Once…
-
Formula in "% Allocation" column does not copy to new rows
I'm having trouble getting a formula to copy when I insert rows. I know about the trick where the formula has to be in the row above and below the new row, that's not the problem here. I have another formula in the sheet for status and that one copies to the new row just fine. There seems to be a limitation with the "%…
-
How to Setup Formulas to Automatically Link & Pull Data from Other Sheets
I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sheet to the next would be very smart or efficient for what I'm trying to do here. I have both a…
-
WBS or PBS in Smartsheet
Has there been any further discussion on implementing this? If I create the hierarchy in a sheet, when i switch to card view, it is not giving me the view of all the "cards" that report to each parent; rather it is sorting by status or assigned to. Any suggestions on how I can work around the system and implement something…
-
Stars Value
How can I convert the 1-5 Stars Symbol into a number using one formula. I have one column Stars and the one with number should be Rating. I also don't know why they chose to have it convert in Excel to Empty, One, Two, Three, Four, Five. Why not numbers? Thanks for any help.
-
Column Copying
Hi, I have a need to add columns to all of my active project Smartsheets and then I need to create a webform on each of these sheets. Based on other posts I've seen, I cannot copy these columns from one Smartsheet to another so I need to manually add them, correct? Also, there is no way I can copy a webform from one sheet…
-
Generic "Forms" embedded in a sheet?
HI, I am pretty new to Smartsheet so, please forgive me if the solution to this question is obvious to most. :) Our company is developing some project management sheets to help us in our transition to paperless. We have put together a template that we feel pretty satisfied with to get going and as we start each project, we…
-
Enhancement Request: Show and allow edit of Working Days when Dependencies are disabled
When working days are set (either by SysAdmin for new sheets or directly in the sheet) and Dependencies are disabled, the dialog implies they do not impact the sheet. But they do. I posted about this today: http://ronin-global.com/2017/06/23/smartsheet-using-working-days-without-dependencies/ Since they impact the sheet,…
