Best Of
Re: Dynamic View Logic should behave like Conditional Form Logic (aka "live")
Smartsheet Developers - the existing 'logic' is pretty useless (and is far from Dynamic!) if it isnt triggered real time as the user inputs values. Whats the expectation, that the user saves each time they enter a value for the logic to be triggered?? That's far from practical. This needs to work as per standard record intake forms.
Dave_Iplex
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
