-
Edit Predecessor Form will not appear in the Predecessor column
I am trying to add lag time to a project but when I hover the mouse in any cell in the Predecessors column nothing happens. The Edit Predecessors form does not appear. Please help, I've tried everything. "To make changes to the relationships between dependents and their predecessors, click Edit Predecessors (hover the…
-
Formatting doesn't work for copied cells
Good afternoon. Can anyone help me with the following issue? I have a workplan on a sheet, where I coloured lines, separating sections of the plan, in a grey. Afterwards I copied a formula to all of the cells in a specific column, while the whole column became white (i.e. it changed grey into white in some of the lines).…
-
Requesting scheduling for events that show up in calendar view
I'm using Smartsheet to request things through different processes in our organization, but one request process that is giving me headaches is requesting after hours air conditioning. We use building automation to control when air conditioning runs, and people have to request A/C if they are using a facility when the A/C…
-
Add up all PAST DUE Items
I would like to add up all the action items on my Action Item log that are Past Due so I can show this on my project dashboard. How do I construct the COUNTIF statement to achieve this? Thank you from the newbie!
-
Columns sorting in a New Report
Hi, I'm to create a report from a sheet which has many colums. In the report builder, it seems I have to select them one by one, and the column list is sorted alphabetically, so if I am to present them in the same order than the sheet, I have to find them in the list one by one. Please, is there a way to create all this…
-
Gmail add on for Smartsheet
The Gmail add on worked twice, but now doesn't place the email into the spreadsheet. It still finds the spreadsheet and the rows, but when you either select an existing row or attempt to add a row the cursor circles for a few seconds then stops and nothing further happens. Not sure where to go next. Any help would be…
-
Searching in Smartsheets - doesn't show ALL possible results
We're having trouble smartsheets in our office because when we try searching for a particular item, it doesn't show all possible results. Is there a setting that we should change to be able to search and view all possible results? As you can see on screenshot 1 the results do not show when I search for CL035 even though…
-
Update Schedule on Mobile.
I am new to the forum, so if I am not searching correct terms please let me know. And if there is already a thread on this directing me to it would be very helpful. I was wondering if there is any way that I can actually update a schedule (finish dates), on a mobile device while I am walking a site? I have both Android…
-
countif help
Hi all, I'm trying to figure out a way to sum the number of one column if it has the value of another column. The formula I was trying is: =COUNTIF(Scoped:Scoped, Channel22) I want to know how many are scoped in the scoped column if the channel header is in row 22. It's reading invalid. Any other ideas?
-
Create RYG Balls for Children
I've spent hours attempting to display RYB Balls for three different drop-down status. "Not Started" "Pending" "Signed" The goal is to have a "Red ball" display in the Not Started Column for the drop down "Not started" in the Quote status children. The formula I'm attempting to adjust - =COUNT(CHILDREN([Quote Status]2 =…
