-
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…
-
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…
-
#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,…
-
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…
-
Slow updates on Formulas and Cell Links
The last 24 hours have been a nightmare. I have been doing maintenance on some of our data sheets which have formulas and that link to roll up sheets. The cells are taking a long to to update -and in some cases haven't updated at all (i.e. I can see in the cell history when the last update "cell-link" update was and it was…
-
RYG formula with a date reference
Looking for formula help with RYG referencing a date column. I want a green ball if the expiration date is more than a year away, yellow ball for expiration between today and 365 days and red for any date in the past.
-
If outcome of Formula is 0 show blank
Hi All, I'm using a formula to count how many stores we have opened in a certain country/month. This information is then used in a chart in a dashboard. The problem is that when we haven't opened any store it shows a zero. This zero is also displayed in the chart, and don't want this. So is it possible to make the formula…
-
Counting Checkboxes for Children
Getting an unparseable error when i do this: =COUNTIFS(DESCENDANTS([Final and Locked]824, 1)) Basically, I just want it to automatically count the number of checkboxes in the next column so when new children are added by other users, I don't need to worry if the formula is capturing the new rows.
-
Amount of Requests per Lawyer
Hello, I'm trying to find out how many requests a lawyer gets per month based on a few things: -AFID (Auto Fill-In Date) -Type of Request = FOIA -Lawyer's Staff name -Status (Red, Yellow, Green, Blue; However, these are not in as words, they're in as "Visual Symbols") This is what I have right now (changing name for…