-
Smartsheet for Work Order System
Hi everyone, New to Smartsheet - very excited about the capabilities. Wondering if anyone out there is utilizing the system as a Work Order System? We get batch work orders from our hardware's proprietary dashboard system via email (excel). I would like to drop these into Smartsheet - using perhaps the help desk ticket…
-
VLOOKUP, ISNA, IF Statement
Hi! I would like to know is this kind of formula available in smartsheet? =IF(ISNA(VLOOKUP(C2;I:I;1;FALSE));"NO";"YES") In short- If there is the same name in other collumn mark YES Thnak you!
-
Newbie please help - is this possible
Hi there I'm new to smartsheet and I'm wondering if the following is possible... I'd like to have a template waiting in smartsheet. I'd like to setup a Google form, when its populated, it would automatically be forwarded to smartsheet, as it arrives a new sheet is created based on the Template I created previously. I would…
-
Continous Merge (Real-Time)
Hi everyone, I am new to Smarthsheet, and I just figured out how to merge a Smartsheet with a Google Doc and automatically send it out in an email. Do you know if it is possible to do this in real time and not as a semi-batch process? Once a new smartsheet row is added I want it to automatically merge and send via email if…
-
Misaligned Selected Box in Smartsheet - GUI
Hi, I have noticed the following after using smartsheet on Windows7 and IE 9.0. It looks like the selected box is mis-aligned which is offset from the box that youa re typing in. I have to switch to a new sheet and back again for it to disappear, but it eventually comes back. Any help would be much appreciated. Kind…
-
Can anyone tell a new user "How long does it take Smartsheet Support to respond?
I submitted a question early today and have received no response whatsoever. I've tried calling and all I get is they're in a meeting or leave your information. Not the best way to begin a relationship. :-( Thank you in advance
-
Time Specific Tasks
Hi I have a project where the time for each task is key during a few days of it. i.e. a task is due to start at 10.00 and continue to 13.00. I may have missed something, but is there a way of creating this rather than just date specific? Thanks Nick
-
Identifying Main tasks & Sub tasks / Identifying last child nodes in hierarchy
Hi All, I'm new to Smartsheet. I would like to know how could I get to know a task is a Main task or Sub task using Smartsheet APIs, My requirement is to consider all the Subtasks (Child rows) in a smartsheet for some calculation purpose. When I see a smartsheet, I can do indentation and I can recognise which is Main task…
-
JIRA Integration: automatically clear completed issues?
Hi Smartsheet Community, We recently integrated JIRA to Smartsheet and are trying to limit the information that flows into Smartsheet. Our goal is to plan the roadmap based on all incomplete tickets (Issues) in the backlog. This means that we don't want to see completed/resolved/done tickets in Smartsheet. The way we set…
-
Assessment Tools
Do any community users use any kinds of assessment tools in smartsheets?