-
Criterion not being recognized when referencing another sheet.
Hello! I am trying to count all of the values in a column that contain the letters "CC:". However, every time I complete my formula it returns with 0 as a result. How can I have it recognize this value? I have posted a screenshot of the sheet I am referencing. Here is the current formula I am trying to use. Any help is…
-
Conditional lookup to create a list from a list
Hello, This seems like a very rudimentary ask but I am stumped. Hope someone can help. Can anyone please suggest a column formula that can bring values over from a sheet based on a conditional lookup to an adjacent cell and list them contiguously on another sheet? Like so: Thanks in advance. JB
-
Need help with nested IF equation
I have an IF equation that is working fine for me, however, I would like for anything that is past due to be "Red" in the task health bar. Right now, because I have "Grey" as the first clause even if an item is beyond it's end date, if it is "0%" complete it shows as "Grey." How do I adjust the formula to make any thing…
-
Help with SUMIFS formula with two columns as criteria.
Good morning, Evening and afternoon. I am struggling with a SUMIFS formula that is using criteria from two columns. I'm not sure if this is affecting the formula or not: The column I am trying to SUM is: Collected: =IFERROR(VLOOKUP([Order Num]@row, {Dell World SKU Import Results Range 1}, 2, false), 0) My current SUMIFS…
-
Booking System in Smartsheets Forms
Hello everyone, I'm a relatively new user to Smartsheets and this is my first post. I have a question please about Smartsheets forms. I work as a videographer and I'm trying to write a form that allows people to hire out equipment (say for the sake of argument we only have one equipment type at the moment at that is…
-
Formula to calculate new date from dropdown
Hi, I have a column where a manager gives a timeframe of '1 week', '2 weeks' or '1 month' to complete a given task from their visit - how do I get smartsheets to generate a new date through a formula with one of the above timeframes chosen from a drop down and show new due date in 'To be completed by column' which has a…
-
Multiple checkboxes in one cell - Formula for True
I have a column asking three questions with the option to check one or all. Is there a formula to test if all checkboxes in one cell have been checked? I would like to apply the fomula to a symobol column where if all boxes are checked it will return a "true" value.
-
Looking for a formula to show the current status
I have created multiple approval workflows and wanted to update the current status in the Status column using a formula,
-
SUMIFS + range + criterion_range between 2 dates
Hello, community, Struggling with a SUMIFS formula. I've created a metric sheet to sum a specific column (E) in a project sheet by month. The column lists quantities for each mission (only at the parent row for each mission), spanning different months and years. While a simple SUM formula for the entire column gave the…
-
Can i get get help with a date formula please?
Hi team, what is the formula to auto populate a date based on another date? ie "date 1" equals 7 days after "order date"?