-
cross refference formula that meets multiple criterias
the problem i have is that there are 2 spreadsheets used by 2 teams, but both should have the same info. in the screenshot, i displayed the different scenarios. I can keep it simple and have returned a MATCH or NO MATCH. The goal is to have the formula return with a value that indicates where the discrepancy lies. if sheet…
-
SumIFS Formula Issue
Hi I need to count the number of total Artefacts if the Process column equals one of four process options. I'm doing this calculation in the Sheet Summary function and I've followed the help guide to set up the formula but I'm still having issues. Here is what I have: =SUMIFS(Total # of Artefacts:Total # of…
-
Text to columns delimited by # character
Hi, I have a column I need to separate from 1 column into 2, delimited by the # character. The output (new column) is consistently 6 characters, but the amount of characters preceding the # always varies. I know how to do this in Excel but would love do this with a formula in Smartsheet. Thanks for any tips in advance!…
-
Struggling with IFERROR syntax in nested formula
I've finally gotten this INDEX/MATCH formula to search 2 sheets and return the correct result but I'm struggling with the IFERROR portion. I think I need a second nested IFERROR. I would like the cell to remain empty if no result is found instead of the #NO MATCH result that currently appears. =IFERROR(INDEX({Clinical…
-
Create a cross refference formula that meets multiple criterias
I am looking to Create a cross-sheet reference formula that meets multiple criteria. see screenshot
-
Using checkbox to add value in another cell.
I am not an expert on excel but I am trying to add value (more specific: adding date/time or just time automatically) to another cell just checking a check box cell. Is this possible on smartsheet? Thanks. Al
-
Linking checkboxes across 2 sheets
I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered data. I want to link a checkbox when any end of day report has a "Install complete"…
-
CountIfs Invalid Ref
I cannot for the life of me get this CountIfs function to work. Referencing another sheet. Plz help! =COUNTIFS({FY23 PWP Meets Objective:Meets Objective}, "No", {FY23 PWP PHC:PHC}, "FFH") Screenshot of my reference sheet columns and values.
-
Issue with CountIFs function
Hi all i'm currently attempting to use a COUNTIF function to count with 3 conditions. However my output comes up with 0 when there are more than 0 items that meet the criteria. Can anyone assist to see if my formula is incorrect? =COUNTIFS({Type}, HAS({Type}, "Storyline"), {Current Maintenance Assignee}, "Earl Prentice",…
-
How do I total the answers from a drop-down cell?
I'm trying to build a dashboard that will show the progress of sites completed for an upcoming upgrade. I have attempted several ways to compile this information automatically and I'm at a loss. I think a simple cell formula might be the easiest way to accomplish what I need then I can link the cell to a report I create.…