Best Of
Re: Calculating Azimuth Based on Departure and Latitude!
I'm afraid this is going to be impossible in core Smartsheet. Smartsheet doesn't have any trig functions or degrees.
If you have Data Shuttle, you could export your sheet to an Excel stored in Drive, Box, Sharepoint etc and that has columns setup with your trig functions. Then reimport the data back to the same sheet with the data from the formulas.
Alternatively you could use Bridge and Javascript to run these functions
Brian_Richardson
Re: Need another expert on formula?
Give this a try:
=IF(AND(Type@row <> "Cost Avoidance", Type@row <> "Optimization", [IMP $]@row > 0, Status@row <> "Dropped", Status@row <> "Hold"), "YES")
Paul Newcome
Re: Need another expert on formula?
Try this.
=IF(OR(Type@row = "Optimization", Type@row = "Cost Avoidance"), "", IF([IMP $]@row > 0, "Yes", ""))
dojones
Why can I not see comment Icon on lines of my Smartsheets?
On my work computer @ the office comment icons when there is one on a certain line but from my phone or at home i can see when there is a comment? Can someone please help?? It's hard to do my job if these aren't visible to me.
Sarah Bruce
Enable multiple views of same sheet within a workspace
I have a sheet that displays information that is valuable as both a grid and a calendar. It would be nice to be able to make a "copy" that is a linked clone of the original sheet in a locked-view version of that sheet. For my use case, the main sheet would live as a grid, then a calendar copy could be made that is locked in calendar view and any changes made in that version would reflect on the master sheet.
beckyb
List of column names?
This might be a long shot but does anyone know if there is a way to get a list of all of the column names? We have a sheet that has over 100 columns and I would love to get some kind of vertical list that has them all listed so I can review them and their order...without having to scroll horizontally and getting confused. Thanks!
laura.sandoval
Re: Using a Form for a Check-in/out build.
Hello @Ty Werven,
First, you can use form logic to show/hide fields in your form. See here for more info.
To show the number of visitors in the Room you can indeed use a metrics Sheet and a cross sheet formula to count the number of rows where someone is checked in for the current room. Note that your dashboard will only update when you refresh it/it auto refreshes.
You can set up a move row automation that will send a row to a Sheet of your choosing (i.e., "Trash Sheet") whenever someone checks out.
Hope that helps!
Re: How to get Join Collect formula to work
Hey @Dakjoekipe
Try this:
=JOIN(COLLECT(Task:Task, [Predecessor Helper]:[Predecessor Helper], CONTAINS([Row # Helper]@row, @cell)), " , ")
The " ," at the end is the delimiter - the separator between textstrings so it doesn't run all together. If you don't want this, you can delete all the entries and have all three closing parentheses stacked all together. If instead of a comma and spaces between entries, let me know if you would rather have it as line breaks.
Will the formula work for you?
Kelly
Kelly Moore
Re: Report Tasks within this week
The easiest method is to use the Filter option in the report, "Is in the next", and put the number of days, 7 for example, to capture tasks that are coming due in the next 7 days.
If you need it to be this week or next week, create helper columns to identify when this week and next week ends and then compare the task date to those dates.
dojones
Use generic name for Smartsheet automated notifications that can be easily updated
When I have changes in a number of Smartsheets due to personnel changes (terminations, new hires, promotions) I have to go through a large number of sheets to change the destination address for the notifications. For example, Kathy might be my accounts receivable person. When she changes roles, I need to change the notifications to a new person. I'd like to put in an Accounts_Receivable placeholder that when the role changes, I can put in a new person to that placeholder and not have to change all the automations. I'd also like to have the option to have the accounting manager get all the Accounts_Receivable notifications. I recommend that we can make a placeholder work globally throughout my company or be specific to a sheet.
John McAlonan
