-
Auto Numbering
Hello, I created a form that employees can fill out when they want to request time off. But when they fill it out the last request is on row 1 and not on the last row. Does anyone know how I can change that around? Thanks!
-
Contact Column shows as email addresses, but I need to extract the First & Last Names
Okay so the title is a bit confusing, but here's the issue: I have a sheet where I need to collect emails so I can send update requests, alerts, all that jazz. Through a form, people input their email addresses into Column 1. Then, using the function =[Column1]@row] in a Contact Column named Column 2, all of the data in…
-
Complex lookup and report data wanted
Good morning all. I have a complex procedure I want to try and accomplish. I have 2 sheets currently created. 1 is for our main invoice for a job, that has a payment schedule and a checkbox colum if the scheduled item has been invoiced. I have a second sheet that allows us to input all of the change orders, their amount…
-
Smoothing out update lag between metrics sheet and dashboard metrics widgets
I need some help gang... I've created a dashboard to display a snapshot of some relevant customer specific values that are stored across several sheets, but I am having some trouble with lag between form submission and updating values on the metrics sheet that feeds the many metric widgets on the dashboard. Essentially,…
-
Is there a formula that will output the row number, and can be used in a column formula?
Looking for a formula that can output the row number, and can be used in a column formula, this mean that it can not have row specify nombre on it like [Column Name]$1 as column formula don't allow it.
-
If formulas with Parents & Children
Hello All, I have been looking for some help with a formula between parents and children. The goal is to have a column to pull a report off of so when it pulls we know it was a child and not just a regular line. The formula works for a Child but when we want the Parent line in the column to pull the parent data it shows up…
-
Could anyone help us create the proper formula? Parent/Children Health based off Due Dates
We are trying to utilize Smartsheet to list out, follow, and forecast our project schedules. The idea is that each Milestone of the Project is the Parent and the steps within the milestone are the children. We are having issues with the parents correctly representing an issue/delay within its children. Right now the…
-
Help With Summing some columns and helper columns
Hello! I have a rather odd situation I am trying to find a solution for but having some trouble. Columns: Column A This is a text field that I am pulling out text from with a MID function to get a count I cannot edit this data as it is being imported from an outside source Column B This is a Formula column I am pulling out…
-
Combining 2 formula's to one for count of days between date ranges
Hi! I am trying to calculate to get a the number of days between two date columns. I have 2 date columns. Date Reported Date Resolved There will ALWAYS be a date in "Date Reported", however, in "Date Resolved" the date could be blank (so I would want to count is as "current day".) I have the formula to get the number of…
-
How to COLLECT() a different reference value for each value in a multi-select column and SUM() them?
I have a cost matrix similar to this staged one: The cost matrix is referenced in a second sheet of "buyer requests" to determine the cost of their request based on the Type, Size, and Vendor they chose: When only ONE Type of Material is requested, the following formula works: =INDEX(COLLECT({Cost}, {Vendor}, [Preferred…
