-
Dynamic drop down Data Shuttle not working
Tried both options of Data Shuttle workflows (upload and offload), but neither is working. I've followed the help article available, but it's not working. Getting stuck at the "map column" section, where it always says that column is not mapped. Any help is much appreciated.
-
CountIF with multiple values in the same cell (same sheet)
Hello, I'm using a CountIf formula in Sheets Summary to count how many times a project manager (using the contact list for my column) is assigned in this year's strategic initiatives. I was able to get it to work with one person per cell, however, I can't figure it out when their's multiple people per cell. Current…
-
License Question for Access to Another Smartsheet Instance
If a user is granted access to another Smartsheet instance (vendor's), do they need to be a member user?
-
SUMIFS Help
I am trying to sum a column with SUMIFs. I have two sets of criteria but am having trouble with the third. I am trying to sum the cost if it matches a project title column, and invoiced quarter column. If the invoice quarter column is blank I want to check if a different column (expected delivery quarter) matches. The…
-
Automated Email
Is there a way to send an automated email to different people per row on a sheet?
-
Dynamic View - delete attachments at row level
In dynamic view there is the option for a user to: see attachments add attachments Please can we also have the option to Allow to Delete Attachments (preferred option) …or if allowed to Add then also allowed to Delete (would also work for the majority) It is quite common for a user to attach the wrong file by mistake. They…
-
Ability to Change a Project Name in Control Center
We have a Department that changed names this year. Our Departments are setup as projects, so to rename it we had to make a new project and move the other projects under this Department. If we could just rename the project this would have fixed the issue
-
Control Center Project Link - Global Change to Rename & HyperLink Change
Please consider added Control Center global change functionality to be able to rename the project links for already provisioned projects. In addition add a control center global change to be able to change the associated hyper link for the already provisioned projects. I run a control center blueprint program for a large…
-
IF FORMULA AND 2 DATE COLUMNS
Hello, I am wanting to capture a date into a current date column if there is a date in the second column. Example: If NEW EXP DATE has a new date, I would like that date to display in the CURRENT EXP DATE column. If there is not a date in the NEW EXP DATE column, then I would like to keep the current date in the CURRENT…
-
Changing the owner on sheets owned by Smartsheet Service Account
We have encountered an issue that when someone has left the company and a ticket was not put in to our internal Smartsheet SysAdmin to move their sheets specifically to another person as the owner, that those existing sheets will default to "Smartsheet Service Account". Once that happens you cannot move those to another…