-
Cell linking broke my sheet!
Yikes. I was trying out the cell linking feature now my sheet is messed up and tells me to log out and back in. I tried to delete the linked cells and save but it won't let me. I can't save or publish. I can't revert..... Reached out to support but hoping someone can help fix. formName: ajax formAction: fa_gridSave…
-
Losing Data & Slow Performance
Hi, just recently my Smartsheet is going really slow, and I'm losing information I've just entered. I can't drag information from one cell to another, and can take 3 seconds or longer to load information, and half the time the file doesn't actually attach. I have to close down and reopen Smartsheet all the time so it saves…
-
Multi-Select Values won't print!?
I used the new Multi-Select function in my sheet and I love it. However, I can't get the second value on the line to print. It's only printing the first value selected. EX: "Responsible" Column: Joe Smith and Jane Numbers were both selected as the responsible individuals for a specific task. On the sheet, they are both…
-
Working and NonWorking Days by Resource
I want to add working/non working days and times to specific resources in one place and when I add that person to a particular project, those working/non working days will automatically follow. I also want the ability for an individual to indicate when they are and are not working for themselves, so that when they are…
-
Count of Completed Tasks by Month across multiple sheets
I am trying to get a count of completed tasks by a team by month across multiple sheets. I've created this formula in the sheet summary: =COUNTIFS(Status:Status, "Complete", [Team Assignment]:[Team Assignment], "Lean"). If I'm trying to get a completed count of tasks for the month of September, how could I get that count?…
-
Autofill formulas not applying per conditions
I have two formulas in my sheet, one that populates with different symbols and one that triggers a checkbox. One formula is using reference to @row while the other is using a specific row number. The formulas are applied to all rows in their respective columns. Neither of the formulas is getting updated when a new row is…
-
Citrix's Sharefile and Smartsheets
Can I attach a file from Citrix's Sharefile to my Smartsheets projects/forms/etc?
-
Flag by Last Modified Date Formula
Hi, I have a sheet for an event we are running and I want to flag any row that has been modified in the last 72 hours (3 days). Right now I have a flag column and a hidden modified date column. Any help with the formula please? Thank you! Jared
-
REFRESH A SHEET
I linked two sheets (A and B) On sheet A are the name of customers from all country with other informations about them. Sheet B is the active sheet, I choose a country in a cell with a dropdown list. On other cells, I use VLOOK link to the dropdown list cells. Finally, by choosing a country name in the drowdown list I have…
-
Default Open to Bottom of Sheet?
When I open a sheet it always opens at the top (row 1.) Is there a way to have my sheets open at the bottom of the sheet or where I last left off instead?