-
Insert row between WBS and append to WBS numbering convention
Is it possible to insert a row between a WBS structure and rather than the added row taking on the next available number I would like to append and additional decimal to the WBS so the order of tasks is not confusing. For example in the screenshot below the WBS is working great, however when I want to insert a row between…
-
COUNT(COLLECT) assistance please
Hi all, I am trying to resolve a COUNT(COLLECT) formula to gather a number of instances from a range of categories by their current activity. In my data sheet the categories are called "Treatment" and I want to know how many instances of a particular Treatment there are by the criteria of Work Activity. I am using a…
-
INDEX COLLECT, how to collect multiple values in a range when the criteria matches
I am pulling employee hours from a timesheet to a billing sheet. The billing sheet has a column that pulls the employee name from the timesheet based on the date, project number and cost code. I copy and paste the transactions into the billing sheet =IFERROR(INDEX(COLLECT({Timesheet | Employee Name}, {Timesheet | Project},…
-
What's wrong with this formula, please? It is returning a value of 0, which is incorrect.
=SUMIFS({Park Bonus - Archive Park Bonus}, {Park Bonus - Archive Division}, [Primary Column]3, {Park Bonus - Archive Approval Status}, [Primary Column]$22, {Park Bonus - Archive Fiscal Month}, [Column2]$1)
-
How to add point values to answers
I have a Smartsheet form that is populating answers from the individuals who fill out the form. The questions are text answers and Yes/No questions and they will all be awarded points. How do I add point values to the answers?
-
Date restrictions or drop down automation
Hello All Is there a way to restrict date fields on a form to only M-F and nonholidays up to a month out? We want them only to select available dates. I am using a drop-down, and I have to adjust the options each week. This form will have ongoing usage. Any suggestions on how to do this best or automate it?
-
How to turn off >30 Flag
I have a flag that turns on >30 days after receipt of a document but what I did not realize is the flag applies to all documents >30 days old, even if complete. What I need is a flag that only activates when two Document Stages are active -- "In Progress" and "Contracting (Customer Review)" the other stages will not apply.…
-
Average of duration
Hi, does anyone know if it is possible to calculate the average of data in a column displaying a duration? They are expressed as 3d, 5d, etc. and therefore it won't let me calculate the average as it doesn't seem to recognize them as numbers. Thanks, Barbara
-
Formula
Please disregard. I have figured it out! I am trying to write a formula that will yield in the SUM = Y - (A + B) Looks like something is not right with the placements of the parenthesis. How to write this formula corrected? Thanks! Tali
-
Health formula help
Hi all, Can anyone tell me what is wrong with my formula: =IF(Status@row = "Complete", "Green", IF(Status@row = "[On Hold]", "Gray", IF(Finish@row <> "", IF(Finish@row < TODAY(), "Red", IF(Finish@row <= TODAY(5), "Yellow", IF(Finish@row >= TODAY(1), "Green")))))) All is working aside from the gray ball if on hold is not…