-
Sumif with multiple requirements
Column A: Team Name Column B: Total Units Column C: Type Column D: Units Won Column E: Units Lost What formula would I use to determine multiple things. Example: I only want to count Column D if Column A = Red Team and Column C = Evergreen Thanks
-
Assistance with formula
I would like to enter a formula that works like this: In first column - I have a Strategic Account Executive. Each SAE has a Book of Accounts In second column - I have TONS of Strategic Account Names - this is the Book of Accounts in full. I would like to have a formula that when I select Strategic Account Exec in first…
-
Wrong date pasted when copying "Created date" to "Date" field in Report
Scenario: A sheet used to track customer request fulfillment has both a manually entered "Date" field and an automated "Created date" field. The idea being if needed, you could enter records after the fact and still track the correct date for reporting. The data needs cleaning. I created a report for staff to easily see…
-
Community Timeline Profile Updates and Public Facing Visibility
Hello - I was wondering if community profiles could allow users to manage the information posted on their profile timeline. 🤔 For example, when I update my profile picture the activity and picture is posted on my timeline and it looks a bit messy (updating doesn't always work out as expected). 😂 Since anyone visiting my…
-
Formula working for half of the IF Statements
Hi there, I'm writing a formula to translate a %complete Column into the progress bar. So far I have teh formula outlined as: =IF([% Complete]@row = 0, "Empty", IF(AND([% Complete]@row > 0.01, [% Complete]@row < 0.25), "Quarter", IF(AND([% Complete]@row > 0.26, [% Complete]@row < 0.5), "Half", IF(AND([% Complete]@row >…
-
Email Delivery Change -Automation
Can we please make who the email automations are from editable? All of my automations come from me and I would much rather make it from our group or organization. (Or vary it based on the end use/user) Thanks so much.
-
Help on project status reporting solution requested!
Hi all - I am tasked with the following and need some assistance and hope you can help. Firstly, let me tell you up front that our organization does not have now. nor can we purchase Control Center, Dynamic View, or any other add-ons at this time. The good news is that my ask MAY not require any, but let me tell you my…
-
Option to Disable Update Confirmation Email Notifications
Hello, My company handles medical record requests for at least 30 clients. We utilize Smartsheet for this process. We recently noticed the update confirmation email that gets sent to the requestor has the link for our sheet. Is there a way to disable these Update Confirmation emails or at least select what's included in…
-
Does anyone have experience with Celigo to Smartsheet API Syntax?
I am using Celigo but have been stumped on proper syntax to update a row in Smartsheet from NetSuite. I am able to identify the Sheet ID, Row ID, Cell ID but have not been able to successfully update a row. Have tried to use different variations of: rows.id[2691881577385860].cells[17].value with no luck. Thanks in advance…
-
Proofing - Comments to persist across all versions
Currently, once a new version of a proofing document is uploaded, it is not possible to see the comments made on a previous version. This makes it extremely difficult to effectively review the new version and ensure all comments have been addressed. Options are now limited to, copy and pasting the comments out of the proof…
