-
Links In Smartsheet Form Not Opening In New Tab
I have a bunch of links embedded in my form. When a user clicks on one of them, it opens in the same tab, negating any progress they made on the form. I looked up some solutions (putting '?&target=_blank' at the end of each link), and everything worked fine. However, after saving and refreshing the sheet/form, the links…
-
Use Contain with And extension?
Hi, I'm trying to pull the correct tuition rate based on MS/M.S. or PhD status and if their department contains Engineering. This is my Active sheet. The formula I'm currently using: =IF(CONTAINS("Engineering", [Grad Field of Instruction]@row), 14750, 10400). So I thought adding the ADD Degree Program = M.S. MS, but unsure…
-
Side-by-side fields in Forms
Similar to other form products (like Form Assembly), I would like to place/format fields within the form with more flexibility. At the most basic level, I'd like to place 2 fields, side by side. My particular uses would be: Dependent Name: Dependent Age: And also: Income Type: Income Amount: I actually could use more than…
-
Help to identify all x.x.1 cells
I have a WBS column that I'm joining with a resource row count to provide a distinction for tasks not just by hierarchy but by resource. I need to be able to exclude the very first task per assignee in the first hierarchy only. How do I identify only the x.x.1 tasks in a column? I need to create a formula for all RBS =…
-
Issue: Banner hides scroll Bar
When I get a Smartsheet banner with an announcement at the top of the screen, it hides the scroll bar at the bottom of my sheet until I dismiss the banner. I couldn't find a place to report an issue so I'm posting it here.
-
TIME Function - Which Time Zone?
I've been looking thru all of the posts regarding the TIME function and can't seem to find where it stated where the time is pulling from. Is it the user's PC time? Is it always Pacific time since that is the Smartsheet default time? How is the time change twice per year addressed? How does a company make sure that any…
-
NEW! Form hyperlinks now open in a new browser tab
Hi Community! We've recently updated Forms so that hyperlinks will always open in a new tab. In order for this update to take effect, you'll need to navigate to your sheet, go to 'manage forms', delete the hyperlink, and re-add the hyperlink. Then click save and you should be good to go! With this update, you can also…
-
Rename Levels
I'm reviewing this discussion but have a question related; What I am trying to achieve is to create Alias's for the following; When level is 1 call it "Header" Where level is lowest level number child call it "Task" Ignore everything else, for example; first child is still a header but its not an important header of the…
-
Sort Grouped Report by Summary Values?
This discussion was created from comments split from: Will there be a way to sort Grouped Reports based on the count of the grouping?.
-
Allow report widget to show calendar view
At the moment, dashboards, it is not possible to have a report showing with a calendar view. This would be a great help for user needing to see data in a calendar format.
