-
Report Colours - different for each client
Hi. I have created a company report showing all client due dates for a particular timeframe and am viewing it in calendar view. All tasks are showing as the same colour, how to I show each clients tasks as a different colour. Thank you
-
WorkSpace Security w/subfolders
When will we be able to add several subfolders to a Workspace, and decide who gets access to each sub -folder instead of always inheriting Will we be able to share folders under sheets in the near future
-
Sights
I am using smartsheet to collect problems and ideas coming from various areas of our company. As a result I have a large sheet in smartsheet where all the data is being collected and then I am using sights to display an overview of problems and ideas. My query is where is the best place or method to gather all the…
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Keeping parent Task during filter search
I have been using the Parent Task as a header for child task below. The child task has an owner, the header does not. I'm in construction so for example the Contract header has child items such as site visit, develop scope etc. My owners don't want to see all the items that they don't own and I have a filter for each owner…
-
Nesting COUNTIF/AND Formula
I am trying to create a formula that returns the count of items past due, 0-30 days, 31-60 days, and greater than 61 days. The formulas I'm using is (respectively): =COUNTIF(AND([Past Due]2:[Past Due]18, "True", [# of Days Past Due]2:[# of Days Past Due]18, <31 >= 0)) =COUNTIF(AND([Past Due]2:[Past Due]18, "True", [# of…
-
Hide Parent Rows
How do i hide or fliter out the parent rows in Grid View. Im trying to link only the data to any other sheet another sheet.
-
Row Level Alerts
Hi, I would like to request a new functionality of adding row-level alerts. I know there is a discussion where Travis mentions workarounds, adding very formula-dependant sheet-level alerts to simulate row-level alerts. But this is a work around, and not a functionality. So this is an official request to add this new…
-
Alerts on tasks
Hello Everyone We opened a sheet of tasks for all employees. How does anyone know when I give them a mission. I know there are alerts , but is there anything automatically, as soon as I gave to someone task will he receive notifications about it ?? Thank you
-
IF Statement searching for dates
Hello All, I'm trying to figure out why my Excel formula won't work in Smartsheets and what I need to do to fix it. I want Column B to return the corresponing date for the stage listed in Column A. My formula that is working in Excel is: =IF(A2="SC",C2,IF(A2="FC",D2,"TBD")) And looks like this in Excel: Stage (Column…
