-
Checking Some Children Rows but Not All
Hi everyone, I'm somewhat new to Smartsheet and I'm still learning about formulas and functions. I have a parent row and 4 children row. If all 4 children rows are checked, that's great but it's most important that the last 3 are checked in order for the parent row to automatically be checked. I set up a function.…
-
Search Projects as Per RYG status
Hi, I looking for solution or moreover a formula to get a project name back as per RYG status. But i am getting problem, i have a same RYG for more then one projects. For example: i want a list of projects As RYG "RED", the selection has to show me 2 projects in retuen Project 1 Red Project 2 Green Project 3 Yellow Project…
-
Scientific Notation
Is there away to get smartsheet to recognize scientific notation in order to add, subtract, multiply, divide, etc.. Thanks
-
Total Sum By Month selected on Dropdown
I need to be able to select to view the total cost of children by a certain month. Currently, I have the dropdown values of all 12 months. I have the formula to the right of the dropdown calculating the total cost recorded for each child. But based on a different month, I want the value to change based on the date recorded…
-
Formula returning a blank cell
I have been trying to figure this out for hours with no luck. We've created a formula to automatically update our status column in our project plan sheets. We have specific parent rows that are designated as milestones. The milestone row status cells should update based on the status of the child rows. A milestone row is…
-
Formula wont work.
Hello, I am trying to use this formula: =IF([Column2]5="","",(IF((VLOOKUP([Column4]5,'Combined Timesheets'!A:[Column2],2,FALSE))=[Column2]5,"Yes",""))) It wont work and I keep getting the #UNPARSEABLE error. Can anyone help me fix my formula?
-
SUMIF a field if box unchecked
I'm trying to sum a column, [Total Commission], if [Rep] is ES and the [Rep Paid] column does NOT have a check mark. It's looking like this so far: =SUMIFS([TOTAL COMMISSION]:[TOTAL COMMISSION], [SALES REP]:[SALES REP], "ES", [REP PAID]:[REP PAID], ??? (this is where I get lost.) Help?
-
Vlookup/cell linking
Hi All, I've been having a lot of trouble with a vlookup formula that I have linking a sheet with ALOT of columns--just under 200. There seems to be a limit to the number of columns to 'look at' (which is 85.) This is the last formula that I have which works. =VLOOKUP(TODAY(), {1. DOR (Pull-out) Range 1}, 85, false) I…
-
Problems using IF formula to calculate status
Hello, First post for a new Smartsheet user. I'm trying to do an status formula. If my % Complete column is 0% then the status should read "Not Started", If the % Complete column is 100% then the status should read "Complete", any percentage in the % Complete column that is not 0% or 100% should read "In Progress". I'm…
-
Formula With a date
I am having an issue with creating a formula that will count a column if a row has a date in it. It can be any date just as long as it has a date. PgM Status is the column with the date right now I'm just counting the section that has the dates but would like to create a formula, so I don't have to keep adjusting in the…