-
Is it possible to set up an If statement on a “Child” field dependent on a date in the Parent field?
What I am looking to do is have a field fill in Yes or No based on the Impacted Article Complete Date in the Child row and the Alert Expiration Date in the Parent Row. If the Impacted Article complete Date is prior to the Alert Expiration Date, the field would fill in Yes. If the date is after the Alert Expiration Date, it…
-
Please help!if certain cells are blank, return to specific answer
If only Financial Risk is filled out AP status should be "1 star" If GPS Recommendation are filled out AP status should also be “3 points” If all 3 successor columns are filled out the AP status should be "5 Star" Thanks a lot.
-
Multiple IF function pull from multiple cells
I am working on a spend tracker and i am having trouble pulling currency conversions from other cells in the row. I need the 'committed amount in USD' to pull from the correct currency conversion cell depending on the currency selected. current formula i have that works with pulling from just one cell is - =IF(Currency@row…
-
Raising Flag for at Risk Tasks
I would like the flag to be red if the date is within 7 days of "today", AND, if "Status" is not "Complete", and I want the flag to be white if the "Due Date" is blank, greater than seven days away, or if the task status is "Complete" I have: IF(ISBLANK([Due Date]9), 0, IF([Due Date]9 <= TODAY(7), 1, 0)) I just don't know…
-
Please advise if you can help me convert this Excel formula to a Smartsheet formula.
I keep getting #UNPARSEABLE when using the following formula: =IF([CUSTODY DATE]7>1/1/2000,IF($MILEAGE$2<=([CUSTODY DATE]7+2),(125+75+40),($MILEAGE$2-([CUSTODY DATE]7+2)*15+(125+75+40)), ) I was told to make this correction, however, I am still having the same trouble: Based on the IF formula provided, $ MILEAGE $ 2 seems…
-
#INVALID OPERATION - Apostrophe catastrophe
Hi Community, I'm trying to convert some numbers expressed in KB into GB so I can sum all in GB. To do this I had to use the LEFT function to pull everything appended with "KB" from a column. That was no problem. I then took the result of that function and did a copy/paste special, so I would no longer have the formula,…
-
RYG Formula
I am trying to make RYG circles correspond to a formula. My current formula, which has anything overdue marked red, anything due today marked yellow and anything not today is green works and is as such: =IF(Finish1 < TODAY(), "Red", IF(Finish1 = TODAY(), "Yellow", IF(Finish1 > TODAY(), "Green"))) I am trying to make it…
-
Copying formulae on sheets where the input is through the forms function
Hi Smartsheet team, My team and I use smartsheet to track our business development opportunities. When we get new leads our team use forms to input the data they need which then adds a new line into our smartsheet doc. However some of the cells in the sheet use currency formulae which do not replicate when we add in a new…
-
Time tracking / Formulas.
Hello, I'm trying to setup the following: • Time tracking spreadsheet with the following columns: Date, Client, Project, Time (increments of .25 hrs) • either in the same sheet or different: Ability to either loop through each row and spit out all projects and time spent during the month. (We Bill each client at the end of…
-
How to use IF(ISBLANK and another IF formula?
Hello, I am trying to create a formula and I need some help. The formula would be in a column which have a single select dropdown option: Update. The formula would use information from two columns. The column names are Level and Latest Update. If the Level = 2, and the Latest Update is not blank, I would like the formula…
