-
How do I create an automation for a client to confirm receipt of a product?
I have a form set up for users to submit when requesting our service, and I'd like to create a way for that client to confirm they received the product at the end without having to send e-mails back and forth or have them physically sign anything. I don't want to give users access to my sheet or reports. It seems that…
-
Require a number format
Is there a way to force input in a form to be in a specific number format? For example, require that a customer number be 10 digits, or an account number be XXXXXX-XXX?
-
Blank rows added after a new entry is created through form, why?
Why is it that it keeps occurring to me that when I get a new row of information (populated by a form) about 10 additional BLANK rows get instantly added on my main sheet? I have to keep deleting this manually and it's just adding a ton of manual work. Any explanations, solutions to this?
-
Repeated Task
Hello all you wonderful SmartSheet users I am trying to find a way to represent a repeated task and the associated information (Start /finish Dates, Status, % complete) from the first time this task is completed. i.e. I have a drawing and its associated sub tasks. This drawing is a sub-task in a later drawing. As such, I…
-
summary of sheet summaries
My project contains multiple sheets that need to be summarize. Each sheet has a sheet summary but since my data spans across multiple sheets, I need to combine the calculated fields in my sheet summaries to be combined (sum, average, count etc). I realize I can create a metric sheet that makes use of formulas and reference…
-
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…
-
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.
-
Implement 'partial match' search on drop-down lists in Dynamic View so it works in same way as sheet
in a sheet - a drop-down list column with allow multiple values selected offers a 'partial match' text search capability so that typing words in the middle of a text string will result in a shortlist of options being shown. This is excellent. However - the same column when used in Dynamic View only provides an 'exact…
-
Multiple checkboxes in one cell - Formula for True (Part 2)
This is a follow question - reposting for visibility. While my original question was answered, I'm now having trouble with the formula. This formula seems to be working, however I am expecting it to return symbols. Instead, it is only returning the "text". Anyone have an idea why...? The column type is set to Symbols and…