Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Looking for similar to collaborate
Short version. 2 years sales manager. 1.5 smartsheet. Company sizee start 500k annually today 3 million. Smartsheet is our only platform. Phoenix. Haven't found anyone that will take me seriously local on smartsheet, have used freelance again lack familiarity. Tried support no follow up back. We have local guy trying to…
Formula help please (Simple if statement!)
Good afternoon, I am having trouble with an IF statement returning a date. It works fine if I ask it to display a text column instead of the date column so I know my formula is correct. Basically I have added a column with a display on calendar or not, so a simple Yes or No drop down. If it is "Yes" display the Event Date,…
Columns
Why cant a shared editor enter a column?
Adding Parent Rows in reports
I am still learning my way around in SmartSheets and need some more help! I have created a report to show all "Past due" actions by owner. The report only lists children as we calculate Past Due status at this level - not at Parent level. Is there any way to include parent rows in this report, even if they don't have a…
Copying a cell that contains line returns adds quotations to the entire cell contents
If I copy a cell that contains line returns to my clipboard, the contents of that cell are contained within quotations. This is problematic for my business since quotations are being unnecessarily added to the entire cell contents. How do I prevent this from happening without removing the line returns?
Functions for net present value / internal rate of return
Hi all, I want to do some financial calculations within smartsheet but I can't find functions that support the calculation of * - net present value or - internal rate of return I haven't found hints neither in the smartsheet help for functions nor in the templates or here in the community. Anybody had the same problem and…
Customize Metadata for Rollup Project Plan
Hi Community: I want to see if anyone would know the way how to customize the metadata for the rollup project plan. I would like to add more "columns" to allow filtering in the Portfolio Scorecard when my projects rolls up into the scorecard.
Need help with an IF AND statement
=IF(AND([Required Weld Size]4 = 0.25, [Actual Weld Size1]4 = 0.5, 0, 1)) I am not able to get the above working. IT comes back imbalaced and I have played around with it with not luck. Can anyone lend a thought?
Sending a shared sheet
When I send a shared sheet to multiple collaborators and check to "CC to me", I get multiple CCs. Is there a way to limit to just one CC to me? Not a big problem, but just an annoyance.
automated email
i want to send a pre-formatted email to clients based on a change of condition. how do i do this?
