-
Friendly Reminders
Hi there, I have two troubles with the tool, I hope you can help me and I'll grateful for that First: I'm automatizating my process with friendly reminders, but these one e-mails their looks like a spam e-mails, I mean, the vowels with tilde doesn't recognize it and show a question mark in that space, this action it's…
-
How to add multiple values when creating a chart/graph?
How I can pull data from a cell with multiple values to create charts/graphs? Currently, the graph only shows/captures single value from the cell and not the other one. Is there a way around how to get this done? For example, when i am trying to build a bar graph for the values under "Hiring Manager" on row 5 -the second…
-
Auto number
I have a spreadsheet where i keep track of all the samples that we've sent for laboratory testing. They all have a despatch date and the lab that they are being sent to. Is it possible to set up the Auto-number system to generate only one number for all the rows with the same lab and date? The goal for this is to create…
-
How to calculate total percent completion only within rows that meet a specific criteria?
I have developed a project schedule that is detailed and has information that should not be shared with the client. In order to provide the client with a summary view, I am using a checkbox column to mark the rows that should be client facing, and pulling them to be shown separately on a report. In parallel, I developed a…
-
Automate Duration Column in Gantt Chart
I'm trying to Great a semi automated Gantt which sets an automatic duration of a task based on Hours, Variance and allotted staff. When task dependencies are on i appear to not be able to write a Formula into this cell. is there a way around this aside from manually doing the maths on the hours every time?
-
Vlookup using Dates
Hello, I'm having some issues around a simple vlookup using dates. I have include screenshots to assist. My formula looks as follows and I am getting a "invalid data type" error. =VLOOKUP([Batch Helper]1, {Site Disposition - database (MASTER) Range 2}, {Site Disposition - database MASTER Range 1}, false) I am trying to do…
-
Send an Email Form Intact to Others
Hello - I have created a form to capture nomination information for an award. The link is on the web where people would enter their information and submit it to me. I then have to send the information to a committee to review and I would like for them to be able to see the form and not the grid as it is harder to read and…
-
How can i tell if an email in outlook was sent to Smartsheet?
I use The Smartsheet for Outlook Add-in frequently and it is a great tool for uploading email conversations and attachments, however there are instances where I'm not sure if I have already attached an email. Is there a flag of some sort that can indicate if an email has been added to Smartsheet, and if so where it was…
-
Smartsheet moving rows
Hello everyone, Bit of a strange one. I have a master list of parent rows each having several children rows. For some reason the order of children rows is changing. I have checked the activity log and no one is editing it and there is no conditional formatting so I have no idea why it is happening. If anyone has any help…
-
Update Status in task list after form submission
Hi Guys, How can I update the status of a task in a task list after submit a form? I just see move row and copy row, but I there is not an option to update a specific record for in a sheet. Is this possible? If yes, how could I do it? Thanks, Andrea
