-
I want items to delete automatically after 60 days.
Hello! I am wanting to have items that were initiated 60 days exactly to delete automatically. How do I do this? I do have a column with the date tab. Thank You.
-
Saving Smart Sheets in storage
I hate having all of these smart sheet tabs. Is there a way to export them to a smart sheet format in another directory? I dont want to save to excel or any other format. I just want to hide my smart sheets off my tabs. Thanx!
-
Issues linking cells
I have created a dashboard linking cells to cells in other sheets. It has been working great. However, I am now running into issues when linking new cells: * 1. The End date is not populated. * 2. The %Complete in the dashboard does not roll up the the group. If I try to link the <End Date> cell it says, "You cannot create…
-
Report Widget Details
Hi Everyone, When i open to select a report, it shows messgae as " you can only select the reports which you are an admin". I have no idea about this. I am using trial for 30 days pack. Can anyone please provide help regarding this... Best Regards viji
-
Request: Formatting and Design of Web Forms
Hi, would be SO handy to have decent formatting options on a web form. i.e. text size, colour, bold, italics centre right margin etc etc etc... I find it hard with black/grey and a few other colours to make things stand out (such as important notes or messages) We look forward to an improved web form
-
Contacts and Web forms
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a field aut populate based on picking a contact e.g Contact name = Gary Bee then the next cell should auto popolate with Gary…
-
How can I calculate the percentage a resource is allocated to each project?
How can I calculate the number of days or allocation percentage a resource is assigned to a project? What I'm trying to understand is the percentage a resource is allocated to a project so I can track the total in a master project list. For example, if a resource is assigned to 3 projects and they are aloocated 25% per…
-
Reference a Cell in another Sheet in a Formula?
Howdy! I'd like to count the number of occurances of a specific value in a column on another sheet. It works great this way, but within the same sheet: =COUNTIF([Column4]17:[Column4]26, "Red") Is there a way to select a range of cells on another sheet and return (in this case) the number of them that are Red? Thanks!
-
Workspace Tabs
I've seen a lot of requests for more functionality around the tabs feature and I have a suggestion of my own. How about a "Workspace" tab that when clicked on offers a drop-down list of all of the sheets in the workspace? I'm thinking the tab bar could be a mix of "Sheet" tabs and "Workspace" tabs. Second suggestion, it…
-
Attaching an item to a column or specific cell?
Is there a way to attach a file (Word, Excel, etc) to a column or a specific cell? I know how to attach an item to a sheet or row, but need it on a column or cell. TIA!