Hi Been struggling with this for ages, I can get the two elements of this formula to work separately but not together - I hope the below makes sense! :) I am trying to get a formula to: A) Search a column on another sheet to see if a reference number is present The below works but gives me the total count…
I have had a quick search and nothing has come up. What are the communities thoughts on a community driven template folder for sharing above what Smartsheet provide. I have read someone wanting LPM (Legal Project Management) templates and Smartsheet are submitting the request. As an alternative would a community template…
Hello experts! I need your help to figure out what's the best way to create a report/dashboard? I have a total of 130 SmartSheets. I need to combine all of them in one. I am not sure if a report and or a dashboard would be the best way. All the columns are the same in ea. sheet, but the second columns (Task Name) What…
Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to return the information relative to that ID for those entries. Thanks in advance!…
Hello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date column to run reports on what equipment were checked out vs. available. We discovered…
Since smart sheet update new version. We are used to able to look details with Grid view.. Now we have to review with grid view and then go to list view and able to see detail...it makes more longer time operate n more comfusion..please we prefer before version smart sheet
Hi to all and thanks for considering my request. We're somewhat new to SS, have looked at all templates without finding a product evaluation feedback form that would allow users to share issues, insight, feature requests and help requests for a 30 day product evaluation period. I'm not expecting to find the EXACT template,…
Hey everyone, working on something that i am having a problem with I have the following =SUMIF({FSM - Help Desk Ticket Tracker Range 4}, $VlookupValue@row, {FSM - Help Desk Ticket Tracker Range 1}) This returns the value from the cell that i want to perform a specific calculation. I want to add more to this though. The…
Hi All has anyone successfully made a risk assessment template within smartsheet ? Im not able to get normal excel formulae to work ( also the templates posted on smartsheet dont work ) appreciate if you could share template with me :D Marie
Is it possible to set up an alarm/reminder with conditionals? For example: I need to send an update request to certain contacts that show in a column that the task is due on a specific date. Thank you