-
Battle over Sorting and Filters
Greetings, We are starting to use Smartsheet heavily in a lot of our processes. We deal with contractors on a daily basis. We have several groups of contractors that view one master sheet and each of their own set of columns they review and work with. They may not directly interact with other parts of the master sheet, but…
-
Project Plan with several Tasks in one Line
Hallo! Currently, we have an Excel sheet, which I would like to transfer in Smartsheet. However I cannot find a way to do so, so hopefully someone can help me. As seen in the picture, every row is an own project and every column (except the first with the name of the project) is a certain day, like a Gantt. So on every…
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
-
Financial/Accounting needs to expand Smartsheet in our company
I don't work in this realm at my job, but I know that another program (much more costly, I might add!) is being considered to meet our business services group needs. Though not exhaustive, I know they need a program that will allow for processing of purchase orders and needed approvals (electronically), timekeeping for…
-
Planning : expected vs reality
Hello ! Does anybody know if how to show on the same line of the Gantt mode, the expected planning and the reality. Here attached is an example of what I need. Thank you for your help !
-
Macro Functionality
Hi, I am using SS to track projects. At the top of my SS I have a master list of tasks with sub tasks. I expand all this out to copy the whole lot and paste them back in at the bottom for my next project. SS does not allow you to simply copy the unexpanded parent row and copy all child rows. My question here is as follows.…
-
#INVALID OPERATION when dividing
I'm trying to do a count of how many staff have uploaded a particular document. I have who has uploaded the document and how many staff in total, and I want to display that as a percentage on the sheet. Whenever I try to divide # of Staff Uploaded by Total Staff I get #INVALID OPERATION. I've tried it both in formula and…
-
SUMIFS with Cross Sheet Date Ranges?
I'm trying to calculate {Expected Premium} sales by {Producer Code} on an enterprise-wide sales tracker that compares monthly sales metrics per [Producer Code]@row against total renewal opportunity. I've scoured the community for answers but I haven't found anything that answers my question as it regards to cross sheet…
-
Not able to moving cards into touch screen monitor.
Hello, I'm using the smartsheet on the touch screen monitor and I have set the appearance as a card view on Gantt charts. With using the mouse I'm able to move cards, But while using the touch on the screen, I'm not able to move them. Please see the attached snap and let me know if there is any solution to resolve it.…
-
Indent not working
For some reason my indent and outdent is greyed out and unavailable. I can't figure out what I am doing wrong. Any ideas is very much appreciated.