-
Pivot on contact list - returns email address
When I use a contact list in a pivot the email address is returned, I'd like to see the name so I can use the Pivot in reports and show the name, not an email address. Is this possible?
-
Formula to calculate the amount of "done" rows for different years.
We do a lot of service jobs that we use smartsheet for. When its done they mark status as "Done". I know I can find the total amount of done rows by: =COUNTIF(Status:Status; "Done"). But how do I make the formula filter for jobs done in 2018 or 2019 etc? Kind Regards, Hugo Martinwall
-
Bidding or External Comunications
Hello- Is anyone using Smartsheet as a tool to manage bidding with external trades? Any info or insight is appreciated! Thanks! Crystal
-
Scheduling by Skillset
Hello! I am wondering if you can set scheduling on Smartsheet, and if you can, a program on Smartsheet for scheduling based on employee skill sets on Smartsheet. If there is, how would I go about doing that, and what ways can we incorporate those skillsets for each employee under a saved file that can be easily edited as…
-
Attachments view window- right pane view
Does anyone know a way to revert the view so that there is the small pop-up window for attachments which is just like the comments vs. the view with the right reading pane. I do not like the reading pane and my team is pretty frustrated with this as well. Not a good change in my opinion. thanks!!!
-
Max Capacity error on sheet w/3,256 rows and 8 columns
I am getting the "this action could not be completed because your sheet as exceeded the maximum recommended size" error on a sheet that I don't think is at the maximum. I have 3,256 rows and 8 columns which, if my math is correct, is 26,048 cells, no where near 200,000. I got the error when trying to add another column.…
-
Date filled in from selecting a checkbox
Community, I want a date to be filled in when I select a checkbox. I came up with the following formula but supplies the current date. I want the date cell to show the date that the checkbox was checked. So for example, if I selected the checkbox on 09/01/19 the date column would display 09/01/19 even though the day I'm…
-
# BLOCKED
Hi, Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error. Originally, the formula was more complicated, so I tried troubleshooting to see which function is broken. Right now, the only thing in the cell is "=COUNT([Task Name]:[Task Name])" All that is doing is counting all…
-
Adjust the Gantt Chart Timeline
In MS Project I could have three lines in my timeline e.g. * Month (July 19) * Calendarweek (W34) * Calendardate of the Monday (04) as in July 4 Is there no way to do personalize this in smartsheet? The timeline-options feels very limited... Thanks! Maire
-
Gantt View - Limit Columns Shown
Hi, I'm trying to limit the columns shown in Gantt View. We have some cells that are reporting info from a link. Sometimes these values are very lengthy. 300 words? The problems is this makes each row very tall in Gantt view, and makes the schedule difficult to read. Hiding these column doesn't help. Is there a way to…