-
Formula Help - 2 columns and % Calculation
I am trying to give a percentage based on how 2 columns read. Column PassFailA and Column PassFailB. If both show Pass 100%, If A is Pass B is Fail or Vise Versa 50% and if both Fail 25% I think this will work, but will take any advice if there is a different way: =IF(AND([pass1]31 = "pass", [pass2]31 = "pass"), 1,…
-
Help with Complicated Formula IF(AND(OR involving % Complete and RYGG balls
Hello there! I'm a relatively new Smartsheet user and I've got an issue with a formula that I could really use your help with. Here's the formula: IF(AND(OR([Initial Draft Due or Task Start]12 < TODAY(), [Requested Edits Due]12 < TODAY(), [Revisions Due]12 < TODAY(), [Final Approval Due]12 < TODAY()), [% Complete]12 < 1),…
-
pallet configurations in smartsheet
Does anyone have a way to figure out pallet configurations in smartsheet given the case specs?
-
Links with Logic
I have two sheets that I want to share information across. Sheet1 contains hundreds of part number records and standard data fields required for each part number. Sheet2 contains essentially a task list of needs to be addressed each of the part numbers on Sheet1. The amount of tasks per part number is highly variable and…
-
Is there a formula that will work for this?
Please see attached screenshot In a separate field (that I haven’t yet created), I would want to know the % availability (based on 40hr work week) of each assigned resource based on each active request status.
-
Human Resources Time Off Requests with Functionality
Hi, I found 2 templates on smartsheets for time off, but neither work, and I have attempted to customize to my needs and I am not able to figure it out. First I want a form that employees can submit their leave, Second create a workflow for approval, and Third be able to tally the balances automatically to the appropriate…
-
IF AND formula for RGY
I am working on a project plan that needs to show the "health" of each task based on the finish date and the status. I've been able to do a formula that checks the status and then selects the correct RGY and I've been able to do a formula that checks the finish and selects the correct RGY but I've been unsuccessful with…
-
CountIF between 2 dates
Hello! I'm trying to count the number of children whose "Final Approval Date" is between 6/1/17 and 10/1/17. I don't even know where to start with this formula. I know I've got my weekly totals like this: =COUNTIF([FINAL APPROVAL DATE]:[FINAL APPROVAL DATE], AND(@cell <= TODAY(7), @cell > TODAY(-7))) Any help is…
-
Automatically Adding Subtasks
I am working to create a Kanban Sheet and Cardview for continuous projects that we do in our office. We have the same subtasks associated with each client through 3 various phases. Is there a way that when I add a new client or Primary/Parent Task, that the same subtasks are automatically added? Thanks for your help!