-
Help with Bulky Formulas/Formatting?
Hi all, I'm fairly new to smartsheet (with no Excel experience either). Here's my situation. I'm tracking POs-- first, you enter in a PO amount, and in subsequent columns what you invoice per-month. There's a final "Totals" column that sums up your monthly invoices. Currently, I have a hidden column set up to test if PO…
-
Finding Duplicates
Hello, I have several sheets. One every month with at least 2000 rows per month. I import the information from an outside source via Excel. Long story short, there is a high probably ability of getting duplicate information from the outside source. Once imported from Excel into Smartsheet is there a way to fnd & delete…
-
Formula for Countdown
Hi, I've read through a few threads and I am unable to re-create a simple countdown formula. I keep getting an #INVALID OPERATION error. Am I missing something? Please help! Thank you!
-
Multiple Allocation % per task
Wondering if there is a way when adding multiple resources to a single task to add also multiple allocation percentages? For example if i am tasking A & B on task 1, but i want A to be at 20% and B to be 50% - is there a way to do that without creating a duplicate task line?
-
Checkbox condition in a child row, conditional formatting of parent?
I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children. I would like any parent row to turn red if any of its children fail a test, as noted by a "Fail" checkbox column, and bonus points for conversely turning green…
-
Formulas for an automatically generated Risk Level
Hi I'm am trying to replicate the below formulas in smartsheet so it can automatically calculate the Risk Level with existing controls and with additional mitigation. The below formulas are currently being used in excel: Formula for existing controls Risk Level: =IFERROR(VLOOKUP(H7&I7,LikeliConseq, 2, FALSE),"") Formula…
-
Does Smartsheets have a Google PERCENTRANK function equivalent?
Hello, does anyone have a solution for the excel / google function “PERCENTRANK()” or the “RANK” function. We want to consolidate our roadmap planning into Smartsheets and use one of these functions to automatically score from 1 to 10 each item in the list. The below image shows how this is done today in Google. The user…
-
sumif multiple criteria
Hi, I can figure out the sumif for the current week but I would like to add another criteria. I keep getting an error could someone help assist =SUMIFS({Week Number}, @cell = (WEEKNUMBER(TODAY())), {Capacity}, {Work Type}, @cell= "Budget") Thanks
-
How to do "OR" in conditional formatting
Hello, I have a column which receives answers from a form. The form is basically a test for nurses. I have conditional formatting set up in the answer column that if the answer arriving is NOT the correct answer, then the cell with the wrong answer turns red. Now the managers decided to change the wording in one of the…
-
Predecessor formula Help
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all…