-
Trying to Sum Rows of linked cells
I'm new to Smartsheet and struggling with a few things, one in particular is wearing me out. I have several rows of linked cells that pull number values from another Sheet. I'm trying to Sum total these linked cells but the basic Sum formula doesn't seem to recognize these numbers. If I remove the Link the Sum formula…
-
Drop downs issues in form
Trying to build a customer feedback form. No idea why but the form does not save the dropdowns as I have entered them. I enter and save it like this 5 - Very Satisfied 4 - Satisfied 3 - Neutral 2 - Unsatisfied 1 - Very Unsatisfied When I open the form it looks like this 1 - Very Unsatisfied 5 - Very Satisfied 4 - Satisfied…
-
Scheduled updates
Is there a plan to allow you to delete transferred owner ship tasks under the edit function? Scenario - I create 10 tasks to "owner 1" - Owner 1 requests for 2 tasks to be transferred to an new owner - I have to delete all scheduled updates for owner 1 - re-schedule, then build a new schedule for "owner 2" Under the edit…
-
Feature Request: Ability to Modify the Working Days of Specific Line Items
While building out a Gantt or waterfall chart in Smartsheet, it is not uncommon to have some tasks that can only occur during a weekday while others can occur on weekends. It would be great if one could modify the working days at a more granular level, that is the ability to edit the working day property of each line item…
-
Not new, but I wonder if there is an smart advance tutorial for Smartsheet for not so smart people
I love using Smartsheet, but I am almost positive I am using just 0.00001% of its capabilities. I appreciate your input.
-
avoid the shared person delete my row
hi, i see some potential of lose of my data if shared to others. for example, my project schedule shared to partnes and they have to update the status, since they are editor and they can delete my row accidently, how could i avoid from this issue to be repeated?
-
Need help on Summing Values based on drop down menu that contains text options
Hi, I have a question regarding using formulas and drop down menus. Similar to an FMEA, I want to have dropdown menus (High, Med, Low) for the severity, occurrance and detectibility. Then I want to have a formula that produeces a RPN (Risk Priority Number) by assigning the value 10 to High, 7 to Med and 3 to Low and…
-
Attachment Permission
Is there anyway to share a sheet but not certain attachments? I have all my sharing permissions set but there are certain attachements I do not want available to certain users. Smartsheet is working great for my team with the exception of attachments.
-
Compare text in two different columns
I have a large SS that includes two rows of columns...one is the listing of the latest print revision, and I want to compare it to another column reporting which revision the part was actually built to. Both of these columns are populated with a letter (NC, A, B....AZ). My goal is a Conditional format color if the two…
-
Planing a load of production
Hello I'm trying to make sheet that I will be able to put orders, amount of planed hours on task and devide for different type of teams, employees. I have stuck on one logic function. At the moment, when not all informations are typed in, function below returns blank cell. =IF(ISERROR(PRORATE($[Total hours]32, $Start32,…