-
if formulas, and adding status symbol (Empty, Quarter, Half, Three Quarter, Full )
Good morning! I need some help with these Smartsheet Formulas. I don't even know if it is possible, but I am trying to get a formula written that captures the status of column "Complete Date". As people fill in the date they completed their task, it will translate the status symbol to the appropriate amount. I am just…
-
Formula in Date Column
Hello, I am trying to get a date value from another sheet in a date column using Index(Collect(.......),1) function. However, every time I add a formula in date column it converts to text by adding a ' sign. For Example: Sheet1 has following columns: Location Project Start Date End Date ... .. .. .. I want to move Start…
-
checked box formula to use for dashboard?
I'm trying to create chart that will show cleared vs uncleared roles. I am trying to apply a countif formula for my sheet but it's not showing the counts. I am using the formula below. Am I doing something wrong Please help! Thanks, Nyasha
-
Pull the first non-blank value from a range of cells in a row
Hello, I have a series of columns that will be filled with a project name (from a dropdown) depending on which column is filled out from my form. I want to have a sort of master list column, that will display the project name for any given row (since otherwise, the project name will be in different columns depending on…
-
How to sort values using formulas? INDEX(COLLECT, COLLECT, VLOOKUP?
Hi, I am trying to sort the values (Machines) based on the "OEE Current Month Column" and referred it to the "OEE_C" (used Large formula). I have used 3 formulas to get the CM Machines sorted based on the OEE_C, first I have used VLOOKUP but when it reached the same values it stop showing data or leave it blank. 2nd, I…
-
# No Match errors with INDEX/MATCH formula
Dear Community I am having the hardest time debugging some #NO MATCH errors with my INDEX/MATCH formula. I have triple checked and can’t find any reason for things not to match. The rows right above and below work fine. I am pulling in the percent complete into a summary view sheet. I am matching on the site name,…
-
Formula to add check to checkbox based on several other checkboxes
Hi all, I am trying to create a formula that adds a check to a checkbox once a check has been added to 5 other checkbox fields in the same row. The other checkboxes are also automated and are checked based on other criteria (however, I don't think that matters here). Below is what I have so far, basically if ALL of these…
-
Countif value matching from multiselect cell
Please help, i have 2 sheets. One sheet contains week no. i.e. the week in which a member is absent. I wanted to count week numbers from that column only if week number is mentioned in other sheet under (multi select cell). Ì used this COUNTIFS({Team Vacation Planner Range 2}, [Assigned To]@row, {Team Vacation Planner…
-
Vlookup on reports
Hi I'm using a report to pull together a number of different sheets. I'm looking to do a vlookup on the report. Is this possible? If not can I select multiple sheets in one vlookup? Thanks
-
Simple Division formula resulting in error and should not be
I am having an issue with a simple averaging formula providing an incorrect outcome. In the example above the dollar amount in the DATA column is a result of a SIMIF formula. Additionally the results in Column4 are the results of a COUNTIFS formula. In Column 6 is a simple average formula that I wrapped in an if statement.…