Best Of
Re: Formula for multiple Criteria
Hi @BonW,
Try this.
=IF(OR(CONTAINS("Invoice", ColumnB@row), LEFT(ColumnC@row, 1) = 1, LEFT(ColumnC@row, 1) = 2, LEFT(ColumnC@row, 1) = 3), "Ready")
Hope that helps,
Dave
DKazatsky2
Re: Update a cell value within an automated workflow
Hi @Naren
I hope you're well and safe!
You could use so-called helper columns: one for the negative value, one with a formula showing the changed value if something else is true, and then a formula in the main column to show the correct value in each step.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: Counting Cells that contain text
Hi @Blake Mears
I hope you're well and safe!
Try something like this.
=COUNTIF(author:author, CONTAINS(1385,@cell)
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: Data Shuttle doesn't seem to be importing from an Excel file when it is closed
I have had a number of similar issue with data uploader.
Currently, I run a number of python scripts (in place of data uploader) and am able to haven't had any issues yet. You can build a pretty simple script that would pull the file from Box, process it and upload directly into Smartsheet.
Ryan
Ryan Kramer
Re: Export meta data from Reports (count functions etc)
A lot of this is going to depend on exactly how you want to display these metrics. Sometimes a report will work with grouping and summaries, but then other times you will need a separate sheet with formulas containing cross sheet references.
Either option can be used to generate a chart on a dashboard.
Paul Newcome
Re: Dropdown in Report
You are able to edit drop-down lists from Reports, however I have seen this behaviour if the type of drop-down column is changed in the sheet without then updating the Report.
For example, if you set this up to be a single-select drop-down column, then created the Report, and finally adjusted this to be a multi-select drop-down column in the source sheet. In this instance, the column is a different type, so the Report is unable to recognize it and you won't be able to edit cells.
Is this possible, could you have changed the column type after creating the Report?
To fix this, try removing the column in the Report, then re-adding the column to see if this resolves the issue!
For an explanation of this behaviour, please see the very last bullet point in this Help Center article on columns in Reports, here.
Let me know if this works!
Cheers,
Genevieve
Genevieve P.
INDEX/Match, to not display "#NO MATCH"
=INDEX({ Range 1}, MATCH([Column0]19, { Range 2}, 0))
How can I get this to NOT display "#NO MATCH" if there is no match?
Mtmoroni
Re: I need help implementing the "OR" function for a SUMIF scenario
See below proper syntax for using the OR() function
=SUMIF([Approval Status]:[Approval Status], OR(@cell = "Approved", @cell = "Exception Approved"), [Total Deal Value]:[Total Deal Value])
Leibel S
Re: Badge Inquiry
Hi @Bobby Kennedy,
These badges will be assigned in the next few days, so you should be able to see it on your profile soon!
Rebeca S.
Re: Select specific person/email as the name for automated alerts
Unfortunately, the proffered solution only only changes who is listed as sending the email. The email headers still include a Reply-To field for the sheet owner. This addresses the concern of Smartsheet notifications looking like spam but does not really help the original issue of people responding to the sheet owner and not the right people in the organization. We need the ability to specify the reply-to address.
katheride