Best Of
Re: Can I use a SUMIF formula to sum children rows?
It looks like this formula is exactly what I need but doesn't seem to be working. Can someone tell me what I'm doing wrong? I get 0 when it should be 3.5
Re: Renaming Column Name in Report
allow me to accept the new name of a column in a report. the current option of disconnect from report is beyond useless. I have already corrected the name of the column in the source sheet, therefore the open source sheet option is also beyond useless. what I need is the option to say yes please accept this renamed column.
Jira Tickets that have been overwritten during a Jira Connector Sync Error
Hello All,
Today, I started receiving abnormal Jira connector sync errors on a workflow that has been working for over a year. I may have received 7-10 or so. The workflow eventually timed out, and the sheet it wrote differed from what it was supposed to look like. This means it pulled in data from other sources in Jira that I didn't need or want. When all the dust settled, the connector overwrote or changed labels on some 80 tickets without being told to. That said, can the Jira connector restore what it was NOT supposed to overwrite? We now have some 80 tickets that need fixing, and we need to know what the original labels were before the sync error. Any help or feedback would be greatly appreciated. Thanks again.
Re: Freeze Row
It seems that user have been asking for this feature for quite some time. This would be extremely helpful.
GENERAR DOCUMENTO AUTOMATIZADO CON INFORMACIÓN DE VARIAS FILAS
Seria genial, el poder generar documentos de forma automática referenciándolo a información de 2 o más filas.😀
Reducing intricacies that need multiple child sheets to 1 simple solution (datamesh bi-directional)
Please please please make it so that you can either do a "report from reports" or have data mesh work in both directions. That or make it so that dynamic view can have logic for which fields are shown based on which column the current user is in.
This is necessary because sometimes a user will be listed as "additional approver 1" or maybe "additional approver 2". But without some way of providing ONLY the columns for that user based on how they are listed on THAT workflow some very significant work arounds are necessary.
Our business wants 1 and only 1 link for people to visit regardless what role they are put into. IE since they could be put randomly in any of 10 roles for that stage of approval, they shouldn't have to check 10 different reports / sheets, etc.
I currently have to have 1 parent sheet, 1 sheet to drive formulas for the parent sheet, 1 sub-sheet for each role (through data mesh from the parent sheet) just so I can rename the columns so I can "stack" them in the final report for users to view. This is more than 15 different sheets and reports with a multitude of datamesh, formulas and links between them all.
What has taken me weeks to perfect and refine and setup only to be thwarted by "if smartsheet just allowed this one minor thing" could be accomplished in half a day to a day at most.
What would be required if small changes were made:
1 main sheet with 1 dynamic view if I could set up logic for columns based on current user matching a specific cell.
1 main sheet and 1 child sheet if data mesh worked in both directions.
1 main sheet and 1 child sheet if I could copy just SOME cells to a new sheet instead of the whole row (much like data mesh)
1 main sheet, 8 reports and 1 main report if I could do a "report of reports"
Re: HELP! Why are access requests going to all sheet Admins?
I am getting so many complaints internally due to these sheet access requests going to all Admins including the exec team. It is annoying to them particularly. I cannot downgrade them to Editor because there are other features within Admin they need to use.
Can a Form Pull Info
I would like to create a form that uses the entries from 1 column in a sheet in a drop box. Once a selection is made the remaining fields in the form populate with associated info from the sheet. Is this possible? It's similar to the dynamic view, but essentially want the detail page to be the form, and one of the field to be a drop down box and when someone makes a selection every other field populates.
Re: Why does my Automation not show checkboxes as cells allowed to be changed?
@CAS the CSA The screenshots and edits you made to your original comment do help clarify exactly what you were looking for.
Re: Automate Trigger Slack DM's based on assignee email addresses in Smartsheet
Another slack suggestion. Thoughts or ideas?