-
Count dates and return a valve from another sheet
I need to reefer to another sheet and count any row that has a "Fill Superintendent" and return a number if it is =< today in column. Then a valve if its => 60 days Thank you for any help
-
Allow a cell to only be certain days of the month
I put together schedules that include public hearing dates that are typically certain days of the month , i.e. 2nd Tuesday, is there a way to assign this to a cell in my schedule? Currently I have to go to that point in my schedule and manually find the date and each time the schedule changes I have to make sure I update…
-
Gantt Print Problem - Can't choose columns to print
Anybody having problems with their "non-licensed" users not being able to select the columns to print in a Gantt view? The "edit" button for selecting columns to print no longer works. I'm wondering if the recent software update has broken this functionality.. We receive an error that says "An error has occurred in the…
-
Formula value
Hi, I have a job file that uses several VLOOKUP formulas to extract customer information, order and delivery date. When the task is finished I would like the information retrieved wirt the formulas to be embed in the task document so the task file can stop looking for the information. I currently use the Paste special but…
-
Project Cashflow
Hi there, I would like to be able to create a month by month cashflow report from a Smartsheet Project (or a number of projects) based on the schedule and Budget Amount entered into each row. ie. Take a standard Project in Smartsheet, which has rows for each task (along with STart and Finish times) and has additional…
-
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!!!
