-
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?
-
Importing\Uploading Information
I know you can create a sheet by importing a document into SmartSheet and having it auto-create around the information; however, how do you continue this? IE You take a sheet from Excel, that will continue to be used, and import it into SmartSheet, then you want to update the information in the SS later by just…
-
Formula Confusion!
We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated! We have a main sheet with all our orders on it, using an older version to muck about with layout at set up at this stage hence the old haulage dates! Each order has details of the sizes…