-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Is there a way to show a particular image in a dashboard depending on which option is selected?
Hi Everyone, I am creating a dashboard that will show which locations are open so the senior managers can quickly check in the morning. It is simple enough and will show on the Dashboard that the location is open or closed through a Metric. I want it to look a bit better so have included a picture of the locations as in…
-
Workaround for =HYPERLINK
Each row has a unique ID and I use this to generate two different hyperlinks in excel with this =HYPERLINK(CONCAT("http://www.XXXXX/",A3),"URL") Is there a workaround in Smartsheets to do similar?
-
Referencing another Column in the same Row after finding the MIN with Criteria
I am trying to find the next upcoming Date and its associated Task based off what activity is being performed and where it's taking place. The formula I have to find the next upcoming date works perfectly: =MIN(COLLECT({Date}, {Date}, >=TODAY(), {Activity}, ="Activity ", {Area}, ="Area")) My problem is trying to get the…
-
Set a value on one sheet if that sheet's row ID exists on another sheet with a certain status
I have Idea IDs that appear on two different sheets (sheet A, sheet B), and I have a column on sheet B called "Update needed?" Sheet A also has an Idea status column. I need a column formula for sheet B's "update needed" to be set to Yes if sheet A's Idea ID=sheet B's Idea ID for that row AND sheet A's status is "Not…
-
Range settings
=SUMIF({Stores Daily Log Range 8}, "1000000456", {Stores Daily Log Range 9}) Hi I am adding figures from the above sheet to another sheet using criterias. everything works until I add another line in the log then the Range does not automatically pick up the new line. Is there a way to do this please.
-
Comparing Three Columns
I have three columns that I want to compare. I thought an If(and( statement would do it but I keep getting #incorrect argument or #unparsable errors. Each column is a dollar amount and I basically want if Column 1 < Column 2 and Column 3 return a value. Below is the expression I've been trying. =IF(AND([EXTENDED COST…
-
How to get an average of multiple symbols (harvey balls) on a single row?
Hi, I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that correlate to each category. I have the columns next to each so I can use the "range"…
-
Formula for if checkbox is ticked
Hi I need to add a formula on the end of this formula please. I need to add if 2026 investment list is checked too. This is the formula =COUNTIFS({Exec Sponsor}, FIND(Metric@row , @cell ) > 0, {Intake Status}, FIND("Project Approved", @cell ) > 0)
-
How to calculate the number of submittals completed each day.
I am currently working on a construction project where I am tracking Request for Information (RFI) for our subcontractors. I can get up to 30 RFIs a day. My question is what is the best way to track how many I process daily? Is there a Countif formula or a DataMesh process that works best?
-
Stock control
Hi I am tryingbuild a new Stock Control system using barcode reader on my mobile feeding into the sheets. The issue I have is adding the items up on one sheet and adding to items to another sheet to work out stock levels. I am tried using the barcode or ref no as the Lookup.