-
IFERROR and MATCH Formula not pulling in formation - Prodactive S-Curve
hello, i came across a Video by Prodactive about S-Curves in smartsheet and so far everything has been working exactly as expected with one major exception; the "Actual" baseline. From the video and the downloaded examples, i used the exact same formula and referenced my sheet name versus what he had in his example. But…
-
HELP: What formula should I use?
I have a data set and one of the columns is a drop down where you can choose more than one option. I am using the Countifs formula because I have multiple owners and i am looking to capture the number of goods that owner has sold. Lets say the one column is Joe, Bill, Tim, Alice and the dropdown options are Apple, Banana,…
-
Row height problem
Hello! I have looked through a lot of searches, and cannot seem to see a resolution to this problem. Sorry in advance if I'm missing something easy! I have a sheet that allows an input word in the yellow box to search another sheet. Looks like this before entry: As soon as you enter a word, and hit enter, it uses a formula…
-
Give Administrators full vision and access to all sheets
I recently contacted support about this and was amazed to find that what I thought would be a simple function doesn't exist. We have had staff leave recently and not so recently and have had requests from senior management to look for data that they may have stored in sheets that they may of owned or shared or transferred…
-
File Library improvements
HI Team, I have few suggestions for improvement to File Library. Folder hierarchical structure for better organization. currently I am using file naming convention i.e. Project Name_FIle name for distinguishing the files between projects, however if there is a possibility of folder creation, it will organize better.…
-
Smartsheet Calendar App Open Form with New Event Button
I am running into issues with the Allow New Event on the calendar app. The required fields are set when you open details and you cannot make additional fields required. Other issues I find are fields that are included for display purposes that would normally be grayed out on an existing element (due to column formula) can…
-
Automation and/or formula in one sheet to change cell in another sheet?
I have ten sheets in our workspace, one is the master sheet that leadership uses to approve department requests, the others are department specific spreadsheets that are populated by a request form for each department to manage their requests. Each department specific spreadsheet has a status field to track where their…
-
App is not syncing to my sheets that view in browser
I have created sheets on pc outside of app and it dosent appear in the desktop app
-
Can you filter a Dashboard?
Hello, I currently have a sheet linked to a form where several employees input projects under their name and we have a calculation sheet for all the activities that feeds into dashboard that shows all the activities for the entire team. I would like to see if there is an easy way to filter this information into the…
-
Row automation - add to top of sheet
Add an option when using automation to move/copy a row to add the row to the top of the sheet.
