-
Indenting
<![endif]-->I am trying to format cells in a budget and I would like to indent the text below certain categories. For instance, in defining cabinets I have to identify the room, eg Kitchen, and then the various cabinets in the kitchen. I understand the parent/child relationship and how this works, however it doesn’t apply…
-
How to reference 100's of items with corresponding triggers to designate an end date.
Hi - Our agency has a formal record retention policy that lists over 100 types of records that we store or have digitized in-house. Question to answer/example: If the documents for Site A fall under Record category 1, they should be destroyed on 1/1/11, which is 100 days following the trigger date. I was able to create the…
-
How to make Gantt bar color dependent on condition: if a task is a child (subtask) of a selected par
I have created a sheet based off of the Team Task List by Priority template. I have changed the priority task names to reflect the names of our team members. This allows me to group the tasks by tech, so the sheet's description would more accurately be Team Task List by Tech. I had conditional formatting set up to…
-
Dashboards
Hi All - I am trying to create a dashboard to be shared with the team(s). Something with colors would be great! A list of all the projects and their status in a graph (or pie chart). Something with colors would be great! Any ideas?
-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…
-
Workspace alerts?
I am trying to figure out if there is a way to send an alert when a new sheet is created in a workspace. I am not seeing anyway to do this. Anyone have any ideas? Thanks
-
Calendar View - Printing
When printing in Calendar view, the names of Months and the Days are very faint, almost unreadable. I can change colour of cells but can't seem to change the names of months and the days to bold or some darker colour. I'm a new Smartsheet user so won't be embarassed if you let me know it is something very simple.
-
Time Function
Imported an Excel sheet that calculates end times for tasks as a start for a Smartsheet. The intent is that we give a start time for the day, number of appointments needed and it builds a schedule, which I can then link with other Smartsheets. It seems the Time Function is not supported. Does anyone know if this is coming,…
-
Header column
Hi All, I am having the hardest time trying to figure out how to keep the top column of my sheet as a header column. Is there anyway to accomplish this in Smart sheets. I have created the form and a web form for users to add data but I want the data entries to post on the sheet under the header. I'm hoping someone can let…
-
Trying to get a formula to work
I am currently trying to get a formula to work in Smartsheet that will count the requests we have outstanding that havent been completed and are over 41 days old. But that will also take into account when new lines are added to the document. The formula I have got working in excel is: =COUNTIFS(B:B,"<"&TODAY()-39,C:C,"")…