-
JIRA Sub-Tasks remaining estimates do not roll up in main task in Smartsheet
Hi. I have a JIRA project that is comprised of tasks and sub-tasks. The sub-tasks have remaining estimates that sum up at the task level. For example, if I have 3 sub-tasks that have respectively 1, 2, and 3 days left are shown as 6 days remaining at the task level. I sync it with Smartsheet, and I use the Remaining Time…
-
Automated export and Automatic upload
Each time a row is added (which is requiring an approval) i need the sheet to export the new data, to either an excel spreadsheet or google doc and upload to a secure site. The other option would be to do this based on frequency like nightly, but I guess the real question for me, and yes I am both new and green here, can…
-
SUMIFS Based on Parent and Children Criteria
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 straight. It would need to be a sum "grand total count", if hierarchy 0 month = specified month and hierarchy 1 matches…
-
time calculation
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 Price total 09:00 10:30 1,5 100,00 150,00 Start and End time can be put in manually Duration must be calculated…
-
Make some fields required in update request form
How can I make some fields required or mandatory when sending update request form?
-
Radar Charts
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 the Graph Types?
-
Data Uploader - Expressions & Repeated Updates
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]+" "+[Last Name] but returned UNPARSEABLE which I would assume is because I am not referencing the line number. Is there a way to put…
-
Search and replace contacts
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). In order to avoid manually entering every contact, I want to search and replace "Project Manager" with "John Doe".…
-
How can I take a concatenated string and feed it into a form as an option?
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 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
Multiple column count
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 boxes and need to count as 1 if a cell is checked in either column. If both cells in the 2 columns are checked also =1. so…
