-
What formula would I use to pull text into a new column?
I want to use a formula to isolate the training type into a single column. Currently, "Training Type" is a primary column so I am unable to make it a dropdown selection and automation would take too long to do (there are over 100 rows). So I want to use a formula to isolate the training type from the "Business Segment, RCM…
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula. This is what I have: And this is the message that pops up when I try to convert it to a column formula: I just don't want to continue to drag the formula down with each…
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that pops up when I try to convert it to a column formula: I like the current formula because it allows me to set up my Request…
-
How do I customize a request ID based on specific form selections?
iaI know how to create a request ID on the column grid but I wonder if I am able to customize based off of specific selections on form submissions. For example, Jane Doe selected content management (CM) in her form submission so the request ID would reflect that (Request ID: CM_0001), where John Smith selected quality…
-
When I double click a column header to change the name
When I double click a column header to change the name, a pop up shows up telling me to double click the header to change the name. Not only have I just done the action, the pop up prevents me from then seeing what I'm changing the header name to! Is this only happening to me or is this a design flaw that needs to be fixed?
-
Why can I not access the Document Builder feature?
Although I have an enterprise plan Smartsheet account, I have never been given the option to 'generate document', which is really confusing and unhelpful as I plan on using this feature along with the Docusign integration for a current work project. Could someone let me know how I can access this or why I can't access this?
-
Formula to find and retrieve a specific value from a list with multiple values
Hi Community, I am not sure what formula or combination of formulas to use for the below example: I have a list of Spring products, each product is sorted into a type, and a similar list for Fall products. For each product I have a column to check if that specific product has an image. In a different sheet (here I use…
-
Merged: Prevent Row Deletion
This discussion has been merged.
-
Add Count Unique function
Please add a COUNTUNIQUE function (or COUNTU for short). It's a pretty self explanatory and similar to other COUNT functions. My intent is to have an automatic Project ID number that is based on the unique project title and I can have multiple entries of the same project title without the ID changing. There is a work…
-
Is there a feature to set a default starting row when opening a sheet?
Hello. I maintain a tracking sheet where new row entries flow in via a form. The most recent entries go to the bottom of the sheet. It is not efficient to have to scroll to the bottom every time we open the sheet. Is there a feature to set a default starting row when opening a sheet?
