-
Taking Average With Grouped Values
Hi all! I am very new to Smartsheet and am trying to come up with a solution regarding taking an average of matching column values. To explain in more detail, I have "Week Of" column and a "Days to Complete" column. I would like to take the average of the "Days to Complete", but only for corresponding weeks. Essentially,…
-
Forms that need to incorporate multiple line entries
We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is filled in and the 'save' button pressed Are we able to set up a Smartsheet form to…
-
Populating cells in a column with data from cells from a different column on the same row
Hi, I'm currently trying to build a column where if the cells are blank, they are populated with the data in a cell on the same row but obviously in a different column. This sheet is populated by form entries and I'm trying to fill this column without making its field on the form mandatory. Thanks.
-
% Allocation Formula for Assigned To column
Hi @Genevieve P. Can you please help me come up with an IF formula to use in the % Allocation column for my sheet? This is what I am trying to formulate: If Bob (from the ‘Assigned To’ column) reaches greater than 100% allocation (from the sum of multiple rows), make the ‘Assigned To’ cell Fill in Red for wherever Bob’s…
-
Calculate Week number from multiple choice dates column
Hi, We are running a Wellness challenge for a charity. Participants log the days and duration when they performed the activity. We allow selecting multiple dates for the same activity. I try to total Duration for a week. "Duration" mean the number of hours for each of the selected days. First, I need to convert a date into…
-
Need help with seeing if a cell contains the quote symbol.
I want to locate " in a cell but Smartsheet wont allow me to run the following: =IF(CONTAINS(" " ",[Column]@row),1,0) Is there some sort of symbol that will allow me to reference this in the quotations of the formula or is there another way to locate this symbol in a cell that I am missing? Using this in a helper column to…
-
how can i sync dates in a column with formula?
Hello, below, I will explain to you the calculation of the termination notice period before the expiry of a contract and the sending of the reminder e-mail to the responsible person according to this notice period; 1- In the first step, I enter the end date of the contract and the notice period on a daily basis. 2- The…
-
Column isn't an option to filter by
fairly new to smartsheets, why aren't all columns available on the list when making a filter? I did not build this smartsheet but am the owner now so I am not sure if it's something on the backend I may not know yet. I need to create a filter with 4 conditions but only 3 of the 4 columns are options.
-
Crossing multiple data bases with a Partial Text/Number match
Hello all! This is my first question. I am building a tracker called "My Project Tracker" that takes information from multiple "master sheets" built by different teams with different purposes. See screenshot for example. "My Project Tracker" has the "Project ID" as user input, then it populates the "Project Name" using the…
-
Setting up a trigger comparing today's entry with the last entry.
Operators will enter Paint Code, Line Speed and the Date is created at the time of entry. There are MANY paint codes. How do I create a formula or workflow or BOTH to notify a manager WHEN the paint code has a lower line speed than the last time it was entered? Example below.