-
Formular: Only two requests each department per week
Hi Community, I have a sheet request form that capture transport requests from each department. Heres my scenerio: For my organsiation a request for transport is allowed only 2 request per week for each department. Requests more than two is automatically cancelled for the department. what formula can I use to a helper…
-
Need to identify who responded in the survey
I have two sheets. Sheet A is the master list of the names while Sheet B is the list of the respondents of the survey form both containing the unique identifier code. I need to identify who has and has not yet responded to the Smartsheet form. Questions: Is there a way to automatically mark Sheet A when a person submits…
-
Leads and Lags / Fast-Tracking Project
Smartsheet could consider creating a formula to lock a specific cell since it is sometimes necessary to block a successor date; it is difficult to add leads and lags and not move other dates, for example, when used in projects with fast-tracking compression.
-
How to Count a value in a drop down / multi-selection list?
Hi, I'm wanting to count the total amount time this value "VAVE" is being assigned to a drop down column. I'm using a summary sheet to collect this data using formulas. So in the request type column(drop down list) I want the total in this sheet. I also want a total by the Brand. I keep getting an incorrect number, like 48…
-
Ignore duplicate rows in a report
Hello, We record certain metrics about our clients anytime they visit our physical location. This usually isn't a problem because they don't come in too often; however, there are a few times a year when they are scheduled to be onsite multiple times a day. This leads to their name showing up repeatedly on the report we use…
-
Can you use a COUNTIF formula to county symbols?
I have a list of goals for the year and we are using harvey ball symbols to indicate the percent complete an the red, yellow, green, gray balls to indicate the health/status of the project. I would like to display a report on my dashboard that shows the number of projects we have in each harvey ball stage and also in each…
-
How can I sum one column based on dates of another column?
Hello, I am trying to sum up the revenue generated during a fiscal year. I have one column titled "Payments Received" and another column titled "Date Received" and would like to tally the totals received for each fiscal year (July 1 thru June 30). I've attached a screenshot of the columns. I have been trying to build a…
-
Quantity deduction workaround
I want to deduct the total "quantity requested" in the "final stock of inventory" after selected the "collected" check box and also wanted to show the available stock before confirming the order, Please help me with the workaround/ formula to achieve this Currently I use this formula, =[Initial Stock]@row -…
-
Check a box if values appear on two sheets
Hi, I'm trying to check a box if a Sales Force ID on my source sheet appears on another sheet This is the formula I'm using but am getting an "Invalid Operation" error. =IF({Sales Force ID} = SalesForceID@row, 1) Thanks!
-
Calculate Average Days When # is 0
Hello, I'm trying to create a formula where we track the days go from sent to actioned on. We have a column where it get's the number of days from sales sent to sales actioned on and that's simple a subtraction. However, when I'm trying to get the average number of days it takes a lead to be actioned on by month I'm…
