-
Grid in Gantt view
Hi, I read in a previous post that grid lines cannot be removed from Gantt charts. I have just created a sheet and when viewing it in Gantt View, one row does not have any grid lines (see screenshot). Is this actually an option or just a glitch? I don't know what I did for this to happen but would like to recreate it.…
-
NOt allowing me to add more rows
Good afternoon I am trying to get my smartsheet to 727 rows but it is stopping at 297? Very strange. Does anyone know why I cant add more rows?
-
Capturing Approval Dates
I didn't see a solution to this anywhere, but I was wondering if there is an easy way to capture the approval date and put that date in another cell. I'd like to use this as a predecessor to another task, and if the approval is late, the other dates adjust. I want approvers to easily see how their delaying approval of a…
-
Edit lock rows
Hi, Can I lock rows and assign specific people to edit it? Example only sales people can edit rows 1-10 and managers can edit rows 11-20?
-
Cross Reference Formula: No "AVEARAGEIFS" so trying to use "AVG(COLLECT(" to use multiple criteria b
I am trying to average how many days a claim has been open for a certain technician. We signify the claim being open by having a certain column being blank... here is the current formula that I have: =AVG(COLLECT({West (Tech Sheet) Range 1}, "", {West (Tech Sheet) Range 2}, "Artur Alimov - ARAL", {West (Tech Sheet) Range…
-
Dashboard Display Current Month
Hi! I've created my first dashboard to report sales data from a sheet that captures 1 year of data. My data rolls up the totals for each week, month and year, currently I have the widgets referencing the totals on the January row. Is there a way to display on the Dashboard the current months totals only and not for the…
-
Edit Column/Row Without Triggering the "Last Modified" Cell
Hi there, I`m trying to create a color code that shows the tows update status. I came up with this formula: =IF(ABS(Modified1 - TODAY()) > 30, IF(ABS(TODAY() - Modified1) > 90, "Red", "Yellow"), "Green") the formula works fine, but if I start working on a new row, I want the color code to be applied automatically, which…
-
Validate if the Hyperlinks in the cell are a valid URL's
Hi, i am wondering if there's a way to validate any External URL to check if it is a valid URL with a status 200. Any help is highly appreciated. Thanks
-
Report shows dates from sheet summary but not text
I have created a sheet summary and copied same format to other sheets. A number of fields in the sheet summary contain linked data from the actual sheet using cell linking. This includes dates and text. When I created a Report (summary sheet) to draw from the three sheets, the dates show up in the report in the respective…
-
Track changes in Dashboards
Hi, Provided that I am "viewer" to a Dashboard item, any way I can track changes to the Dashboard(including the attached Sheet, attached files, attached item,etc)? Thanks. Ben