-
Method/formula to rename sheets, reports and dashboards in a folder
Have a folder with 15 sheets, reports and dashboards used as a template folder. Titles include (Clear) as a generic placeholder in the folder and used in the 15. When a new project is started, we "Save As New" that folder, replace (Clear), with the project folder name and do so for each associated sheet, report and…
-
Returning Open or Closed based on conditions
Referring to Row 6 I have a Status column and that can be Open or Closed. It depends on the condition of the Progress column which can be selected from the following dropdown menu. The first 4 conditions mean the Action Item is “Open”. The last condition means the Action Item is “Closed”. Dropdown: - Not yet submitted -…
-
Concatenating multiple Smartsheet fields into a single JIRA field
I have a need where I need 3 different Smartsheet form fields to be concatenated into a single JIRA field. For example I would want these 4 from My Smartsheet fields: * Description of Request * Expected results * Why is this info needed * What resources have you utilized To all be entered into the Description field in…
-
Adding an additional requirement to a formula
We have been using this formula to add up the hours spent working specific clients -- been working fine. We have also been asking what category of work they have been completing at these clients but haven't been utilizing the data. =SUMIF({Kinsman - Job#1}, [Scope of Work]@row, {Kinsman - Hours#1}) I now need to add an…
-
Automation - Request Update
Hi. I'm looking for help troubleshooting an issue I"m having with Automation in smartsheet. I set up a recurring request for updates to run each Friday at 8:00 AM PST to all Assigned To users in the sheet. The problem I'm having is my request automatically includes a form I created for project intake. I do not want the…
-
Assistance with IF AND Formula
Hello, I am trying to create an IF AND formula and get stuck after a certain point as I am a bit green when it comes to Smartsheets. What I am looking to have it accomplish in general terms: IF the status is set to High AND the Status is marked as Complete, then input Today's date in the Completion Date column. Can someone…
-
Smartsheet + Jira workflow - attachments and multi-select
We are using a smartsheet to populate a jira project. basically, a user fills out the webform, it updates the sheet, and then we push that into jira. The first issue I'm having is attachments. Is there a way to attach the attachment to the new jira story created from the line item in the smartsheet? it doesn't appear as an…
-
VLOOKUP cross-sheet, if the search value's parent = @row
Hi all, I'm trying to populate an entire column on a sheet using both cross-sheet and in-sheet references. I'm trying to return a value according to the following logic: Looking for cells cross-sheet that contain "Opening Date" and returning the value from the cell to it's right (also cross-sheet) if that particular…
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Cell linking broke my sheet!
Yikes. I was trying out the cell linking feature now my sheet is messed up and tells me to log out and back in. I tried to delete the linked cells and save but it won't let me. I can't save or publish. I can't revert..... Reached out to support but hoping someone can help fix. formName: ajax formAction: fa_gridSave…
