-
Yellow rows.....
Can someone help me understand the why the yellow colored rows are showing up? And how to fix it? I think it has something to do with dates but cant seem to figure it out. See the attached screen shot. Thanks much.
-
COUNTIFS Formula
I'm having a hard time figuring out the formula to use if I have a column of dates and I want to count how many cells fall between a date range. I have tried the following formula and the results came back with 0, however I know there there are 7 cells in the column that fall under the date range. =COUNTIFS(Date2:Date73,…
-
Issues automating dashboard that feeds from a sheet with calculations
I am wondering if there is a solution or way around this issue in Smartsheet. I noticed that the reports function in Smartsheet does not allow you to do calculations such as countifs, sumifs, averageifs, etc. It only allows you to make graphs/metrics to report on if the information you are pulling from is number related.…
-
Vertical Layout for Alerts
Is there a way for us to control/customize the format of the alerts we receive between vertical or horizontal? We prefer the vertical formatting over the horizontal as it is easier to read and the formatting carries when we have to forward the email. I have several sheets where when I first set-up the alerts, they came in…
-
need a function to set permission to one cell,or one column
need a function in smartsheet to set permission to one cell,or one column, it means, the viewers can view most of the datas in the sheet,but one or two cells,one or two columns,take the classified column within revenue for example, the datas inside of this classified column just can be viewed by owner and admins, the…
-
Report Builder: Adding Column in report that does not exist across multiple workspaces
We make use of multiple shared workspaces and users then create a report that shows them all line items that they have been "Assigned To". A user would like to be able then have a column available to her to enter her prioritization to work on the items. For example, she may want to use a number system 1A, 1B, 2A, etc. or…
-
Problems with Levels in Card View Mobile
Hello! Does anyone else have issues with Levels in Card View on mobile (Android)? It appears that the Level view gets reset when leaving sheet -- and even worse, If I set the display to "Level 1 and subtasks", and then I add a subtask, it will switch the display to "Level 2"! (and all my main tasks will disappear). I was…
-
Recurring Weekly Tasks
Hello, I've seen a couple of entries related to this, yet I think my question is simpler. Is there a click somewhere that would automatically populate a weekly task? For example: "Review Meeting", from 3/31/18 to 7/31/18, must occur weekly. Is there an option for this, similar to my Google Calendar? Or do I need to copy…
-
When adding a collaborator to a sheet in a workspace, does the message get sent to just them, or eve
When adding a collaborator to a sheet in a workspace, and I choose to provide a message with it, does the message get sent to just the person I'm adding, or to everyone in the workspace? I have searched and have not been able to find a solid answer to this. I ask because when sharing a sheet in a workspace, there is a…
-
RYG ball to change with expiration date
Hello I would like the ball to be red if the date is in the past, yellow if the date is within the next 30 days and green if it is set to expire in more than 30 days. Help? TIA
