-
Universal Name Ranges
I'm looking for an option to create a universal name range that I can use across all sheets. I have created a sheet that contains the following columns Team / Office / Division I use this to translate reports that only contain Team info into Office and Division level reports by using a =VLOOKUP. However, every time I need…
-
Travel Ticket
Hello, Do i have the option to create a printable shop travel ticket/WO from an entry that's been created thru the online Forms. Right now we use Word to copy all needed info of smartsheet manually. Trying to automate this.
-
Is there a way to copy the contents of a cell from one sheet to another?
I am trying to make a metadata sheet, that pulls data from multiple other sheets. I cannot use cell linking, because I use forms to capture data. The form inserts a new row into the sheet, which doesn't have the linking. I've read cross sheet formulas can accomplish this, but I can't seem to figure out how.
-
Can I concatenate a field call with a predecessor field #
I am looking to call a field based on the content in the predecessor column. In this case, I can manually type in "='is blocked by' + [Issue Key]9". Once Issue Key is populated (let's say Issue Key = HelloWorld01), this will read as "is blocked by HelloWorld01". The following row may read "HelloWorld95". Rather than typing…
-
Date Formula Assistance
Good day, I need assistance in setting up a formula for tracking next service dates on equipment. I have two sheets - Sheet 1 is a schedule of Workdays and Sheet 2 is where the various equipment are listed with previous service dates etc. Sheet 1: Sheet 2: C3: Workdays: C1/C2 Question 1 C4: C3 + C7 (this must be based on…
-
Some issues with this function (Countifs with Weeknumber)
We are using the below formula to count how many people are "Complete" during the current week. It was working yesterday, and earlier today but has now stopped working and I am unsure what caused it. The only changes were just adding additional rows to next week's totals, but the value continues to show 0 for this week…
-
Sum of Cells when another Cells Fall In a Certain Date Range
Hello Smartsheet community! I have a sheet that has a column for a Delivery Date, and another column for the Qty of items to be delivered. Delivery Date - Column A Qty of Carrots - Column B I need to put together Summary Data to know how many Carrots are needed for a specific date range, example the month of June? Thanks…
-
How to subtract a month and have it be the same day of the week of the month.
I have a bunch of dates where I would like to subtract one month, but need it to be the same day of the same week of the month. For example, if the date is on the second Thursday of the month, then the result should be one month prior, but also on the second Thursday of the month. However, my dates are all on different…
-
Profit percentage calculation
Hey all. Trying to get a profit percentage formula. Columns are: "Price Bought" "Price Sold" I want to get the profit between the bought and sold, so if I bought for $1200 and sold for $1000, that's 20% profit ($1200 / $1000 = 1.2) What's the correct way to do this?
-
Formula assistance
Hi, Could someone please help me understand why my formula doesn't work. What I am trying to achieve is: IF today's date is between the CI Start & CI Finish, then return "Consultants Inspections" IF today's date is between the BSI Start & BSI Finish, then return "Building Surveyor Inspections" IF today's date is between…