-
PICK CHART and Smartsheet Template
A PICK Chart is a very effective Lean Six Sigma tool used to categorize process improvement ideas https://www.vertex42.com/ExcelTemplates/PICK-chart.html I am still a newbie using Smartsheet -- is there a template or can SS be created to match the example "Action Item List with PICK Ranking" shown in the above URL (near…
-
Round up & If Condition
Hi, Hope this message finds you well. In Ms Excel, we have following function available, how can we have the same in Smartsheet? MROUND(AVERAGE(V2:Y2),0.5) Moreover, need to implement the same formula in smartsheet. IF(OR(AA2>0,AB2>0,AC2>0,AD2>0),"C","NC") Thanks in advance :)
-
Allow inline editing from the attachments tab
Allow inline editing from the attachments stab instead of having to download the attachment so that is NOT read only, make the updates, save and then upload the new version. Saves a lot of steps if you have the ability to edit the documents right within the attachments tab.
-
Report Colours - different for each client
Hi. I have created a company report showing all client due dates for a particular timeframe and am viewing it in calendar view. All tasks are showing as the same colour, how to I show each clients tasks as a different colour. Thank you
-
Conditional formatting in Calendar View
Is there a way to extend conditional formatting to Calendar View? I did notice that if you click on an individual item you can change to desired color. But my project extends over 2FYs and has over 1000 items, so individual formatting is not an option. Thank you.
-
Nesting COUNTIF/AND Formula
I am trying to create a formula that returns the count of items past due, 0-30 days, 31-60 days, and greater than 61 days. The formulas I'm using is (respectively): =COUNTIF(AND([Past Due]2:[Past Due]18, "True", [# of Days Past Due]2:[# of Days Past Due]18, <31 >= 0)) =COUNTIF(AND([Past Due]2:[Past Due]18, "True", [# of…
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
IF Statement searching for dates
Hello All, I'm trying to figure out why my Excel formula won't work in Smartsheets and what I need to do to fix it. I want Column B to return the corresponing date for the stage listed in Column A. My formula that is working in Excel is: =IF(A2="SC",C2,IF(A2="FC",D2,"TBD")) And looks like this in Excel: Stage (Column…
-
Counting the number of check boxes
Hi Please, can some help I have a sheet that uses check boxes and trying to count the number of boxes in that have been ticked. I am using this formula however it just returns a value of count 0 Any Ideas ="Count: " + COUNTIF(CHILDREN(Sent47:Sent1), 1)
-
Conditional Formating : Done/Status based on items below it.
I am using a sheet to tract information being sent by candidates. Is it possible to make the Red Dot in the "Done" Category next to "Candidate Name" Turn Green automatically when all lines associated with it are turned to green/done. I've been trying to get conditional formatting to work but I can't figure out what the…