-
how to combine multi formula conditions
Hi team, Trying to create a vehicle luggage capacity calculator for small and large cars, Please find below, Please find the below Formula: =IF(AND(Passengers@row <= 4, [25 Kg]@row <= 2, [15 Kg]@row <= 1, [7 Kg]@row <= 1), "Yes", "No") The formula above indicates the col [Result] is "Yes" in the ase of follows: The number…
-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce
-
Counting Checked Boxes in one column
Hello, I am trying to count the number of boxes that are checked in the "Missed Information" column and showcase the total in the bottom right corner of the Sheet. I have tried many different formulas: =COUNTIFS([Missed Information:Missed Information], 1) =COUNTIFS([Missed Information : Missed Information], 1)…
-
AI tool to Document Workflows
It would be great to have an AI tool that would create a visual map showing how sheets, reports, dashboards, etc and interact in a workspace? This would help with debugging, documentation and training.
-
What are Your DataMesh Use Cases - Dog Photo Attached as a Bribe for Your Response
Hello Everyone, I'm looking into what people are using DataMesh for within their companies and their own workflows. We just started a big push at my company for SmartSheet and are currently using just the core product. Being broken up by region/market/geography we end up with a lot of fractured data sitting in a bunch of…
-
STATUS UPDATE - Based on Date
Hello, I want the process wherein once we click on the task status for example: In Progress then start and end date are added, time time line status will read it immediately if it is "ON TIME" or "DELAYED" based on the end date. If we click on the completed - and the end date is not yet on the past, then it will ON TIME -…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Merge multiple columns into a single column on another sheet?
Hi, I have 3 columns on the same sheet (C1, C2 and C3) and I want to Merge them into a single column "A1" on another sheet. Is this possible in Smartsheet and how can I proceed? Thank you for your help. Best,
-
Want Dashboard to Update with Data Live Based on Report
Hi - I want a dashboard I have created to update with data live based on the report I have input into the dashboard. Is this possible, by which I mean can a sheet update live based on a report so the metric widget reflects those numbers? If not, what are other solutions, and if a formula is needed can you give me the…
-
CountIF for whole column Not just a range of rows
I'm trying to count the numbers of "text a" appears in an entire column. This is the formulas I'm working with, that both produces an unparseable error are: =COUNTIF(contains("Resident Instruction", [Resident or World Campus Offering])) =COUNTIF([Resident or World Campus Offering], ="Resident Instruction") What am I doing…
