Best Of
Apply styles/settings to multiple sheets
When managing many sheets it would be great to apply style/settings to many sheets in order to be able to change them in one place. I have few idea: sheets that inherit the same template inherit the template style. Or sheets under the same folder/workplace user inherit styles/settings.
Duraid
Re: Formula for counting days
Since you are using NETDAYS are you looking to eliminate weekends? If you just want to calculate the number of days between two dates, regardless of holidays or weekends, try this:
The Difference Formula is:
=([Date2]@row - [Date1]@row)
If you are always going to subtract the earlier date from the later date, this will return a positive number of days. If it's the opposite, like, Date1 - Date2, then multiply by -1 at the end to get a positive number, like this:
=([Date2]@row - [Date1]@row) * -1
If I am not understanding your question, or what you are trying to achieve, please let me know.
Best!
Pauline J
Hyperlink Formula to Display Text or Image
I have a link being generated based on the information from multiple cells within each row on SS. I would like to have that link embedded into an image, so when a user clicks the image, it takes them to this row specific link.
Is SS planning on adding the hyperlinks formula ['=HYPERLINK([cell containing generated link], "text or image that I want to appear"). This feature would clean up my sheet very nicely instead of seeing the https://www..... links all over the place.
OR! does anyone know of a work around to make this happen for me??
Form Continuity I
Allow a form entry to be a drop-down list with options consisting of those created in column properties in column creation or new entries entered through the form. An example would be a project number, if a line already exists with this project number or if it's a number that was pre-populated as an option during the creation of the column, it appears as a choice and you can select it, if not, you can enter a new one and it then becomes a choice.
We have other sheets with all these project numbers, so using those to create the options for the dropdown list in a new sheet would be even better.
The plan would be to use the above or some other tag to tie data from multiple forms to fill different columns of the same line. Example would be different forms for project requirement questions to be answered by different people. Each has a separate form, but with the same tag (project number) their entries would populate the same row in a sheet.
CBT
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
