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…
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…
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…
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…
Is there a way to display the value of a cell from the last row of children in a given parent row cell?
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…
I have the data connector up and running. I am able to have it take info from Smartsheets and put it into excel. This is awesome because one I press refresh it updates everything in that excel file. The only question I have is, is there anyway that the data can be updated into smartsheets if I change it in excel? We have a…
I have a formula that says it is an incorrect argument. When I break up the two arguments they each work, but they are not working together. The error message is incorrect argument. I don't know why they work alone, but will not work together. Here is what it looks like when I added them together. Can someone tell me why…
We would like to be able to send an email encompassing a couple of rows with attachments (Invoices). The recipient of the email needs to be able to access the invoices as attachments as a computer reads them to populate their accounting program. The computer is unable to read the invoices if they appear as links to…
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…