-
Auto-Numbers and using them to seach in smartsheet and pull up rows
Hi All, Is there some nuance I'm missing with using auto-numbers to search in smartsheet? I have a sheet with an auto-numbers column, and a form that's inputting data. Currently using auto-numbers in search isn't pulling up any results even though the ref used for the search is there in the sheet. This is the reference…
-
Free user limitations - inserting rows and columns, and customising columns
Hi there smartsheet community! New poster here :) I'm needing to know more about the limitations of free user accounts. Specifically I'm wondering if free users are able to insert rows, or customise/insert columns into sheets that are shared with them. I've looked everywhere, and although there's great general advice and a…
-
Can I make my dashboard interactive with check boxes?
Hi - we currently use an intake form for new projects upon receipt of a purchase order. We do not always have the final information needed for engineering to start, so I need to create a way for the PM to add this information to the master data sheet (without creating a new row) and kick off a workflow to notify…
-
Conditional Formatting
Hi All, I am trying to use conditional formatting to format a cell based on if the contents of the cell is greater than the contents of another cell in the same row. For Example if one column has expense info and another column has budget info how do i get the Expense cell to change format when higher than the budget. I…
-
Can users sort reports on the Andriod mobile app?
I currently share a report (I am the Owner) with my team. Team members are editors. My team member, working in the field, wanted to sort the report in the app. We can't find that functionality available in the app and we can't access the Smartsheet desktop version, because Smartsheet automatically signs them into the app…
-
Sort Disable
Hello Guys. I was wondering if you can help me with this, I'm having an issue with the sorting of a sheet, it has at least 2200+ entries, and somehow or someone (I have like 20 people working on it), sorted it and now people here lost track of where they were working. Data didn't move at all. Is there a way I can lock…
-
Report will not allow me to choose one of my sheets
I'm trying to create a report for one of my sheets, but for some reason I cant select it! There is another sheet that has identical columns/permissions as the one that I want to use that I can select, but for some reason not the one I want. What could i be doing wrong?
-
Formula to populate parent from one column in another?
Hello, I'm am combining a bunch of sheets in one and then reporting off of that. For reference, the application is resource tracking, so lots of project plans that I'm combining in one so I can report at a "portfolio level". Is there a formula that will do this? I want the parent text from the Task Name column to populate…
-
Calendar View - Display More than One Date
Is there a way to display more than one date column on a single calendar? I have one sheet with multiple date columns and I'd like to see an entry on the calendar view for each of those date columns, but it looks like you can only view one column at a time.
-
Export to Excel loses hyperlinks
I've read a lot about how hyperlinks hidden behind texts will not export to Excel from Smartsheet. Are there any workarounds for this? I have a report that collates 170 schedules, and the Sheet Name column contains a link to each respective sheet, which is great, if I remain within Smartsheet. However, we are using Power…