-
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…
-
Can I link an entire sheet into my master sheet?
It looks like I need more than Cell Linking in our master project tracker. Do we have the ability to add a section on our master sheet so that any updates from a separate MARKETING TEAM sheet is displayed in the master sheet? I'm afraid simple cell linking only focuses on cells and won't take into account additional rows…
-
Activity Log Export
Is there a way to export the Activity Log once filtered? We would be able to use this for our metrics. It would be a huge time saver and really make SmartSheet that much better for us! I am sure this could be used in this manner for other companies as well. Thank you!
-
Using a modifier to derive month (formula de-bugging help
Ok. so I've set up a rolling dashboard built around the today function - something like this. Everything rolls over automatically as it all references TODAY() to determine the various derivatives. (see screenshot) It's great, but doesn't scale (yet). The Month column uses this right now - =IF((MONTH(TODAY()) + Modifier5) >…
-
Gant Chart Timeline in minutes/hours
Can i show my giant chart in minutes/hours rather than days?
-
New multi-select Field functionality, Feedback
I don't like that in resulting Excel dump from Smartsheet that values where I multi-select values, LOVs that resulting Excel filter does not have a space