-
CountIFs (Time and Blanks)
We use Smartsheet to provide customers with an invoice and allow them to give us a PO. I am wanting to create a formula that will count invoice past 90, 60, 30 days that have a blank in the PO #. I am pretty sure I have FINALLY figured out the date function, but can't figure out how to "marry" it with the blank function. I…
-
Recreating the formula imported from excel
Hi All, I've recently posted with regards to automatic breakdown of hours based on duration and budgeted, however, no luck. I tried re-importing the file from excel with formulas and this is what I'm getting (see pic). Could you help? There is a formula used in the END DATE which is working fine (not sure if necessary to…
-
COUNTIFS nested formula help
I'm trying to get a count for multiple solutions but am getting the '#NESTED CRITERIA' error. =COUNTIFS({Rapid Response Delivery Tracking Range 6}, CONTAINS("Meal Replacement", @cell) + COUNTIFS({Rapid Response Delivery Tracking Range 6}, CONTAINS("Meal Replacement - 2nd Solution", @cell))) Essentially I need it to give me…
-
Currency conversion based on own sheet
Currency conversion data is saved in one sheet, based on months and years as per our corporate exchange rates. My "main" smartsheet includes my forecast; for reporting issues, it should look-up the PO date and either utilize the latest exchange rate of currency conversion sheet (if PO is forecasted and date is in future)…
-
COUNTIF Query
Hi All, I'm trying to run a query to group and count certain status' in order to count them as a single statistic. For example: If there's 4 'New / Reported' tickets and the 'Pending External Clariication' has 5 tickets, the OPEN tickets box would show 9 OPEN tickets. Ticket classes: Open ticket = The status' (New /…
-
FORMULA NOT WORKING
HI, I have a formula =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you in advance :)
-
Automatic Breakdown of budgeted hours into cells
Hi all, I was wondering if there is a possibility of creating a formula that would autopopulate cells based on months duration and budgeted hours? E.g. if my study starts in september 2020 and lasts for 10 months, it would autopopulate cells in respective columns? (see snapshot of how the sheet looks) Many thanks
-
Reporting on who and how many times an individual has attended events
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all the data about who is attending our events is in multiple sheets. Using email…
-
Index Match help
I am trying to convert from Excel to Smartsheet without adding a ton of columns to make this work. I am not if Index/Match is the way to go OR VLOOKUP, etc. Again, the entries from the operators will vary therefore the low/high specs are used in previous columns that you helped me with. This is the excel version of ONE…
-
Help with Cross Sheet JOIN(COLLECT) formula
I've built a formula to complete a JOIN(COLLECT). If I put the formula on the same sheet as my column references it works just fine, however when I move this to a separate sheet and update the column references to the other sheet I get the error #UNPARSEABLE. From what I can tell I haven't removed any of the formula…