Hi I am pretty new to Smart Sheet and have mainly used it for Project Plans so far. I am now looking at using it for forecasting for delivery consultants. I have created a sheet and form for them to enter forecasting for delivery for a particular customer in a given month. I would however like to be able to create a…
Hello everyone. I am working on a sheet that will store files sent by third parties. But currently It does not give me the option to place a field to ask for attachments on the form I am working on. I started to use Smartsheet recently, so it can be quite easily to solve this problem, so please be patient. Ty all
Hello, I have pay dates on the 15th and the last day each month. A person may be contracted for say 21 days and that pay needs to be parsed out depending on what days that employee worked in that time period. I am having a hard time coming up with an equation for each pay-period cell. Pay, 1/15, 1/31, 2/15....
Hi all, I have multiple budget spreadsheets and a related report which I point to one budget sheet at a time. I can then report on just one month at a time (example: project A, October totals). Is there any way to sum the cost column for the items returned in the report?
So I am trying to get different sheets to communicate. I need it to where when a specific box is checked then it unlocks a whole row in another connecting sheet. Is that possible?
I'm new to using Smart Sheets and looking to calculating aging date for invoices for tracking purpose. I tried several ones I used for excel but does not seems to work here. I did also use some of the formula's people had suggested on the blogs here but no luck. Please help. What I have is the invoice date and need to know…
I am trying to create a formula that will calculate sales commission based on which marketer is named in another column. I have two marketers who are at different commission levels. I would like the Commission column to automatically calculate the commission total from the dollar value in the Services column, based on…
I created some Dropdown List fileds and I did not retrict the values. When I test this field on the forms it doesn't allow anything but the values available. Any suggestions? Thanks!
Can the description of each symbol be changed? Thank you!
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
