Hi there! I am trying to make a master reporting sheet that is just a sum of another source sheet based on specific criteria of parent and child rows. It's a two step SUMIFS that I can't seem to get s…
Hi there, I am a newby here and I must say that smartsheet looks good. The only thing I am definetly missing is a way to calculate time This is what I need to show: Start End Duration h Price per hour…
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into…
Hello, I have three questions regarding Data Uploader. 1) In my source excel file I have First Name and Last name. I tried to build an expression to concatenate the fields (used =[First Name]+" "+[Las…
Hello everyone! I'm having some issues getting my head around the search & replace function: I have a standard project task with placeholder values for assignees (Ie "Project Manager" or "Consultant).…
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 f…
Need help with a formula. It is to count total sites upgraded either to a interim or final result, but if the site has had an interim and a final it is only counted once. I have 2 columns with check b…
I am not finding the error in my formula, Client is a text field and Start and end dates are Date fields. Any help would be greatly appreciated Regards Michelle =IF(AND([Client]1= "In Progress", [End …
There is a new release coming. Yay! We were all just summarily notified of the upcoming release and the expected downtime. Any chance we can get a list of proposed changes included in the release? And…