-
Insert a formula into a reference name + Summary sheet fields
Hi. Is there any way to use a formula (or simply a cell) in the reference name to another sheet? For example, this formula takes the first enrolled student from a source file using a reference name called Module1_Name when there is a "Yes" in the Enrollment column: =INDEX(COLLECT({Module1_Name}, {Module1_Enrollment},…
-
Only Unique Contacts Formula
I want to create a column formula that pulls all the contents of multiple contact cells @row and only print the contacts that are unique. I don't want to print the same contact in there twice if here happens to be duplicates. Additionally, this needs to be a "contacts only" field so we can reference this for alert…
-
#DATE EXPECTED Error
I am trying to create an email reminder automation on one of our project schedules. We want the alert to go out 10 days before the line is set to be due (Finish Date Column). I created a date column to generate the reminder date (for the automation to use) by subtracting 10d from the finish date column. Some lines in this…
-
Replacing or adding/subtracting values into a cell
I've done some researching and trying to wrap my head around this what I thought should be a simple formula. In my Storage Bin Inventory sheet have 1 Column with the current quantity for any given storage bin. As we start to migrate more into SS, I've added 3 new columns into the sheet that are designed to be "input"…
-
Formula to add leading zero to months 1-9 of the year only.
I need to add leading zeros to month numbers Jan-Sept only as sorting by month number does not work due to Months Oct-Dec starting with number 1. If I sort by month number, it comes up like this. 1 (Jan), 10 (Oct), 11 (Nov), 12 (Dec), 2 (Feb), 3(March) ... Does anyone have a formula for this?
-
How to correctly refer to another sheet for COUNTIF?
Hello, I am new to smartsheet and trying to create a dashboard for my source sheet. I have created a blank sheet to help add all my formulas. 1. I have a source sheet - "MySheet" 2. It has a "Category" column and is a multi-select dropdown list 3. The values are Engineering Roadmap Process Change Administrative Hiring…
-
Restricted dropdown list - multiselect with limit
Hello, When we have restricted dropdown list with multi-select option, is it possible to restrict the selection to how many can be selected from the list? Example: select any 3 from the dropdown list of: January, February, March, April, May, June, July The user should be limited to selecting only 3 from the list. Thank you…
-
Which formula should I use?
I'm trying to calculate the total of an item in a column. However I then wish the formula to only calculate of that total those figures which meet a criteria of another column. So for instance Total how many Pens in a column, which are labeled red in another column. Probably really easy, but new to Smartsheet's. Thanks for…
-
Nested If
Hi, I'm trying to create a nested if statement (below) and have tried each of the if statements individually and they are all work fine. However, once I combine the statements in the nested if statement is returns #UNPARSEABLE IFERROR(IF([Engagement : Currency]@row = “AUD”, [Engagement : Engagement value]@row *…
-
Sheet loading issues - taking too much time to load the sheet
Hi, I have a order intake sheet where I refer the stock quantity from Item master sheet and grant amount from Grant master sheet. I'm doing most of the calculations(like quantity check and cost check) in the order intake sheet. in the particular sheet I have nearly 16 formula columns and multiple sheet referencing due to…