Best Of
Re: Please let Smartsheet work with time
Hello,
I was hoping that a time selection option for the field settings in the sheets. Currently, there is a current date/time stamp function that captures the time when the row was created, but being able to select a specific time would be beneficial in organizing workloads
AKalsi
Re: IF/OR Formula Issue with writing
Hi @Lydia Bowman,
If I've understood you correctly:
=IF(AND(HAS([Add-ons]@row, "Prebill"), [Final Invoicing]@row = "Invoiced"), [Prebill Actual Invoiced]@row + [Final Invoicing Amount]@row, IF(HAS([Add-ons]@row, "Prebill"), [Prebill Actual Invoiced]@row + IF([Final Invoicing]@row = "Invoiced", [Final Invoicing Amount]@row, 0), SUMIF([First Draft Invoicing]@row, "Invoiced", [FD Actual Invoiced]@row) + SUMIF([Final Invoicing]@row, "Invoiced", [Final Invoicing Amount]@row)))
Sample output (probably with some scenarios that shouldn't happen around pre-bill invoicing):
Hope this helps, but if I've got something mixed up then just let us know!
Nick Korna
Enable Smartsheet Desktop app to adhere to EntraID Compliance settings
It would be great to enable the Smartsheet Desktop app to adhere to EntraID logon methods such as passing device information so compliance can be checked. This will make it possible for companies that enforce device compliance to be able to utilize the Smartsheet Desktop app.
cthomasnec
Re: Unlock the Power of Interactive Dashboards in Smartsheet: Control, Customize, and Create with Ease!
@akhalid - thank you for posting this. I believe you're aware that large organizations and corporates follow strict guidelines with regards to software usage and third party downloads. At Verizon, we do not have the option to pick and choose just any add ons or connectors randomly that are not "company-approved" and that is vital because we are governed by confidentiality, compliance and security protocols.
We need Smartsheet to include a looker studio capability in our existing enterprise/business plan or we won't be able to use it. That's why I added the question/request to Smartsheet.
Thank you,
Ipshita
Ipshita
Re: March Question of the Month - Join the conversation and receive a badge
My notes taking ability while in fast paced meetings.
JM2863
Re: March Question of the Month - Join the conversation and receive a badge
Listening is a skill I would like to improve. It's very important to me. While I recognize that and try my best, I could use some improvement as my mind tends to drift.
Ray Lindstrom
Can a Form field be auto populated?
I have a form that all Project Managers complete each week. When they open the form I would like to auto populate some of the Form fields with data from various sheets. Is there a formula that I can add to the form that will retrieve data from a cell elsewhere in Smartsheet?
Greg Gibbons
Re: March Question of the Month - Join the conversation and receive a badge
One big skill I've been working on is self-gratitude. We're often too hard on ourselves, and it's very easy to have thought patterns that lean towards negative language. Re-training my brain to use positive language and affirmative statements has been tougher than I thought but so important!
Monique Odom Stearn
Re: March Question of the Month - Join the conversation and receive a badge
One skill I'd like to improve is quilting. I’ve always admired the art and creativity that goes into it, but I think I could really benefit from learning more advanced techniques and improving my stitching precision. It’s a relaxing and rewarding craft, and I’d love to be able to create more intricate designs!
mcullen
Copy some columns from rows to another sheet
System