-
##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…
-
Scheduling an Update Reminder like an Alert
This is a test sheet (screenshot attached). I am trying to set up a method to where an Update Request is automatically emailed to the sales rep 3 days after the trigger date (Bid Date). This functionality is in the Alert Module, but in the Update Request you have to manually set a date each and every time; keep in mind I…
-
Revenue per month Formula extending beyond 1 year
I have a sheet that I have created to forecast revenue per month based on forecasted schedules and dollars/project. Currently this just goes for 1 year, but with projects now starting late Q4 2017 and going into Q1 of 2018, I am needing to revise this formula to add a year definition. Would love if someone could take a…
-
Setting conditions for RYG balls
I would like to have the RYG balls automatically adjust based on another status column. For instance, if my outside sales people set the status of a row from bidding to the following: Status "Lost" = RED Status "Postponed" or "Unknown" = YELLOW Status "Won" or "Obtained" or "Negotiating" = GREEN Status "Bidding" =Will…
-
Update requests not updating
Hi, Please can somebody help me with what seems like an easy process of requesting an update, but is not working. I have done selected the rows and cells that I require updated and sent them to an external stakeholder as per the documentation and videos. The first attempt did not actually update the Smartsheet, I had to…
