-
The link out arrows have disappeared?!
I have two SmartSheets in use. One for my engineering team, and one for my construction team. I have hundreds of cells linking in and out of both sheets to one another. For some reason the cells which are sending the data (Linked Out) are not showing the little black/grey arrow within the cell, but the cells which are…
-
PTO/Sick Accrual Calculations
I started a new job and a bit overwhelmed. I am new to Smartsheet and a basic user with Excel. I need help with PTO/Sick policy calculations within Smartsheet. I do not know where to begin. Any help is appreciated!
-
Form stopped working
A form I have been using for weeks has stopped working, I've not changed anything on the form and the sheet. When I choose to send my responses I get an email with the data I entered but the sheet doesn't update. the sheet is empty at the moment so they aren't going to the top or the bottom and the count on the form for…
-
If/Then formula with two options based on a date?
Hi all, While I am getting the hang of Smartsheet, I'm still a novice with formula. I currently have a column formula =[Record Entry Date]@row + 8 This adds 8 days to the "Record Entry Date" to create an "Archive Date" for each row. However, I now need to adjust the formula to be either 8 days or 30 days, depending on the…
-
INDEX/MATCH returning #NO MATCH error but only for ONE cell
I have the following formula checking for matching emails in two sheets & returning the date: =IF(Done@row = 1, INDEX({Submission Date}, MATCH([Email Address]@row, {Submission Email})), "") It's inside an IF statement because the Done column checks if there's a submission for the email in the first place--I only want the…
-
Rows being inputted randomly?
HI, I have a smartsheet form that connects to an intake tracker. However, when the form is submitted it moves the form data to random rows and now row 1. Does anyone know why smartsheet does this or what the solution might be? I need this solved quickly because I am creating this intake process to be handed off to another…
-
Inventory Management (relationship workaround)
Hi, I haven't actually started this in Smartsheet because I don't know where to start. I have an inventory list (excel) that itemizes on multiple rows against one PO#. Like this: Line 1. PO# 12345 Item: Desk Qty 5 Line 2. PO# 12345 Item: Table Qty 4 Line 3. PO# 55555 Item: Chair Qty 3 I am trying to see how I can get that…
-
Align column order in grid view...
I've duplicated the same sheet to contain completed project rows according to fiscal year. I've needed to change the order of the columns in one of the sheets and would like that same order matched to the other sheets. If this is possible, how? This is in grid view.
-
Formula to look at specific column/cell depending on the current month
Hello, I want to create a dashboard widget that will show employee FTEs for the current month. I currently have a sheet (Capacity Plan) that list out the employee's name, and then has the assigned projects with FTE breakdown as child rows underneath. Then I have row that calculates the total for the month. For the widget,…
-
IF Formula with Multiple Criteria
Hello! I have a software enhancement sheet, and I am trying assign priority to each enhancement based on the level of effort (LOE) + change priority calculated score. The LOE can be one of the following: 1 - Unknown, 2 - High, 3 - Medium, 4 - Low, 5 - None The change score change range from 4-25 The breakdown for priority…
