-
Index Match another Sheet
Hi there, I need help with structuring this formula: =IFERROR(IFERROR(INDEX({Program Duration}@row, MATCH([Program Name]@row, {Program Name}@row, 0)), INDEX({Program Name}@row, MATCH([Program Name]@row, {Program Name}@row, 0))), "") I want to index match column information to another sheet. The column names are the same…
-
Stacked Bar Chart Data Sheet
Hello I am trying to create a stacked bar chart based on the following: I have a multi-select dropdown column, so there may be more than one value in it. I then have a second column with Priority listed. I have created a sheet that calculates how many times each drop down is used but I want to know how each drop down…
-
If Contains Formula
Hi there, I need help with putting together these 2 formula's: If "How does the Company make money or plan to do so?" selection does NOT include “Other” then show below: [Name of Company] makes or plans to make money through [Other] If "How does the Company make money or plan to do so?" selection does include “Other” then…
-
Using formulas to populate the sheet summary, would like negative number to be red
Is there anyway in the sheet summary to have a negative number coming in by a formula to be red?
-
Help with formula for Current, Next, Last week calc based on date
I admit.. I'm gonna be lazy on this one. lol. I'm brand new to smart sheet. We have a field called [Due Date] that is a date type field. I want to create a string field that follows this logic: IF [Due Date] occurs during this week THEN "This Week" ELSEIF [Due Date] occurs next week THEN "Next Week" ELSEIF [Due Date]…
-
CHECK BOX IF TWO CELLS MET THE CRITERIA
Hello, as you can see, I have a form and if a employee selected a certain date and certain time, what is the formula to tick or check the box on the circled part of the picture. Please share with me the formula. Thank you
-
Sum up values with #NO MATCH error
HI All, Some of the cells that I want to sum up are a "#NO MATCH" which is fine as those values are based on other formulas and there might be no value for them. Now, trying =SUM(IFERROR(Cellsrange,0)) is not working, its giving me "0" as a result which is incorrect.- see attached. Please help as its really painful doing…
-
Countifs Reference Another Sheet - Help
This is the formula I am trying to use with reference to another sheet. Range 5 I want to only count if ticket status is "resolved" and Range 6 if in the month of Dec 2023. Error "Unparsable". =COUNTIFS({Field EDI Request Sheet Range 5}, [TICKET STATUS], "RESOLVED", [{Field EDI Request Sheet Range 6}, (LAST STATUS DATE},…
-
#INVALID COLUMN VALUE error
Hello Community, I'm trying to combine two formulas but keep getting an error. The first formula sums children if it's a parent row or leaves the cell blank. The second look for the most recent data in a row (I have month in the columns from July to June). They work independently but when I combine them I keep getting an…
-
Need to identify the current month plus the last 7 days of the prior month
Hi there, I have a helper column that checks the "Current Month" check box if the date is within the current month: I used this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) The business is now asking to identify when a date is in the current month or in the last 7 days of the previous month. For example, this month…
