-
Duplicate Columns in Report
Hello, I have four different promotional calendars that I am trying to merge into a summary. Each has month/week/day/date columns. When I create the report I want one set of those columns and then the promo/notes/$ etc from each individual sheet. Is this possible? It's very unsatisfactory to have four rows of dates with…
-
Project Management
Hi, we currently have a few web forms, that allow clients to request quotes. These then populate fields on a smartsheet as normal. We have two challenges that I'd like to implement but can't seem to get it right. We would like to give the client more visibility on the status of the opportunities, but for various reasons,…
-
Netdays - if blank
Hello all -- I have created a column to show me how many days between "today" and the expected close date of a sale. This is the formula I'm using: =NETDAYS(TODAY(), Close Date16) This is working, but I have one problem: I don't always have an expected close date. In those situations, I want the cell to display as blank.…
-
Pending Report - Formula Assistance Needed
Y'all... I struggle with formulas. Please help! On our sales tracking sheet, we track probability of the sale closing, expected close date, and the price low and price high of each potential sale. I'm currently using a modified version of the Sales Pipelne with Summary template. In addition to the summary (that shows…
-
##Help ME please "i can t continue to work" SumIF##
I post a problem 2 days ago some response but still doesn t work, new to smartsheet but my work is blocke now problem Hello @Craig and other Helpers i experiment the same issue than other sorry for my english but i m french i copy your formula below and try to adapt with "laserjet" type i want to make a sum if a name…
-
Indenting not working right
See screenshot. When I indent my headers, the expand/minimize button is all the way to the right (circled in red). I would like it to be in the cell with the header label. I cannot figure out why it keeps putting it all the way at the end. Second- When I try to do additional indenting below that point, it doesn't seem to…
-
Uploading large excel sheet
Yes, I read the blog posts from 2016/2017. I tried loading a sheet with 32 columns and received an error message indicating I had over 200 columns. In my opinion, the error message is misleading. Submitted this to SmartSheet support. Just wondering if anyone else is having an issue of this nature.
-
Convert gannt chart into monthly revenue forecast
I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…
-
Query String Syntax
I am having an issue with a query string syntax. See below. Trying to populate two fields when I send this out. I actually wish I could populate the form from data in the sheet but i dont think I can. Please take a look I have tried multiple different things Trying to populate an Order Field and a Name field…
-
sumif date is today to end of month
Trying to write a formula that doesn't need manual updating that basically sums a total amount for file that have a closing date from today to the end of the month. Seems like it should be fairly straight forward but I cant get it to work. The sheet has parent rows but i want to include all rows in all parent rows in the…