-
Future Date Calculation
Hello, I am trying to find a formula that will calculate out 90 days from a given date AND give the result as the last day of the month. The given date is Completion Date Estimate i.e. 10/31/2017 of a project and I would like a cost cut off date that is 90 days later on the last day of the month i.e. 01/31/2018. One…
-
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…
-
Troubles with inputting a value for notification
I am creating a sheet to keep track of a budget process. I am curious why a notification does not get sent out when I input a value by typing it in when using the "is one of" condition? The notification only works when I already have 100% typed in the column somewhere, then I have to select it from the drop down box. Why…
-
Conditional Formatting Do not modify current value if condition in other field fails
Without creating another column, I am trying to update a current value only if the condition is met in my modified by field. My formula (below) works when the condition is met. How do I tell SS to leave the current value as is if the condition is not met? =IF([Modified By]1 = Owner1, " ", Modified1) Background: Above…
-
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…
-
Consolidated SmartSheet
Hi all, I am pretty new to Smartsheet and in need of some help. We are using smartsheet for an upcoming budget task. I have created over 50 different sheets. In each sheet there is a column with checkboxes. I want to have a user check the box when the specific task is completed. My question is, is there a way to create a…
-
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…
-
Microsoft Flow - Inserting a new row on a sheet with Dependencies enabled
Hi, I'm currently trying this out to see if we might use it more widely in my organization. I'm trying to insert a row using Microsoft Flow, but I am receiving the following error: * End Dates on dependency-enabled sheets cannot be created/updated. Please update either the Duration or Start Date column. Based on another…
-
LastChild() function?
Is there a way to display the value of a cell from the last row of children in a given parent row cell?
-
Formula Help
This might be simple, but I can't figure out a good formula for dates. What I have is a column with dates, and another column (Year) next to it that is hopefully an If statement. Something like IF the date is in 2015 THEN put a 15. I need this column so I can reference this Year column when calculating total investments…
