-
linking checkboxes between two sheets vice-versa
I have two sheets full of checkbox’s. Sheet 1 is a summary page Sheet 2 is a working page Sheet 1 gains automatic inbound ticks linked in from cells in Sheet 2 However, my question, is, in the Summary page (Sheet 1), I would like to sometimes tick “off” a cell AND THEN HAVE THE ASSOCIATED Cell in SHEET 2 automatically tick…
-
Text toolbar on report
The reason we decided to use Smartsheet is because there is some information my colleague and I need to share with each other (for instance contact names, emails, and renewal dates), but other information is purely of interest to one of us and not the other. I had the idea to create a filter for columns the same way I do…
-
How do you edit existing URLs/Links on row attachments?
Is there not a way to do this? See pic
-
Anything like pivot tables?
Is there anything similar to a pivot table capability in excel? I am trying to graph and analyze text - not numeric values. I figure I can make a secondary sheet in which I can do the formulas I need but I was trying to figure out a way to do this with minimal upkeep.
-
Email Alert colors
Hello! Recently we updated some of our reports with the new automation. However, only two colors (green and red) are populating in that automated email. We have yellow and blue that are not showing. Can anyone assist? Are we doing something wrong?
-
Updating date columns
I have a due date column that was manually put in shown below. Next to it is how often the task needs to be done. Is there any way to set up an automatic formula that will create a new due date after the current one has passed, or will I always have to go in and manually change the due date for each task after the one has…
-
Vlookup and automated number column
I have a Vlookup function in one column and I have it set up to return information when certain criteria is met by selecting information from an adjacent cell. If no selection is made in the adjacent cell or in the rest of the row, my auto-numbering column still populates a number even though the entire row does not…
-
Adding a grid to a Form
Hello, I'm wondering if there's a way to add a grid to a Form to collect data when multiple names, emails and job titles are submitted. Currently we ask people to submit a PDF form to us that has an embedded table where they list the staff who have taken a training. The table headings are: Name, Email, Job Title. Sometimes…
-
Create a Gantt Chart from a imported Calendar
Hi, I recently imported a production calendar from Google Calendar. The calendar booking room is the equipment that is required for production and the times are listed ie 9AM-10AM. I was wondering if I could then create a Gantt chart for project. I attempted to switch to Gantt view but it requires two dates columns. Is…
-
Send form response
I would like to send/print my form with completed responses. Just sending/printing the row does not work, as the form has more information than the column names - is this possible?
