-
the end date and the gant chart date is not matching
Any body has a problem similar to this: I set the end date at 2018, but the gantt chart showing a 2019 ?
-
Multi Formula/Sheet Help
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…
-
Community Template Section
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…
-
Analysis of information
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…
-
return list from another sheet
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!…
-
Date changes to tomorrow after 5pm
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…
-
All technicians preferred old Grid view...
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
-
Looking for some guidance: need recommendation on the best template to use with client to track feed
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,…
-
SUMIF IF referred sheet/column ISDATE
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…
-
Risk Assessment
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
