-
Export row data to Powerpoint or Google Slides
Hey Team, I'm hoping there's a way that I can export row data to a slide presentation (pptx or Slides) similar to the way I can export row data to Google Docs. Anyone have any suggestions? Ideally each row would export to a different slide, and each slide would be in one presentation, but I'd be happy if each slide was…
-
Best Formula
I have a construction schedule with start and finish dates. I want the check boxes for the at risk column to automatically check off if the project is late starting or late finishing. Can anyone help me craft the appropriate formula for this? Is there a good formula for this? I was thinking it would be an if then formula…
-
Drawing row linked data into another sheet together?
Hi All! So I have a sheet with a list of tasks, a checkbox for completion and a due date. In one of my other metrics sheet, I am trying to generate a list of my top 5 overdue tasks. I have managed to get a list of the most overdue dates with a SMALL(COLLECT...) function which will only count dates that are not listed…
-
File attachment counted as a change to a row
I currently have two workflows set up: (1) Payment approval request after an event: employees submit request with invoices attached as a file for approval (2) Payment approval request before an event: employees submit a request for an approval, the request gets sent to a supervisor, and once the supervisor approves, an…
-
Child Text Indented formatting
When you have a Heading Row and Rows below that are Children of the Heading Row, is it possible to have the text Left Align and not be indented? Thanks, Tm
-
Voting on a Worksheet
I have a sheet that are shared with a group of 25 members, which contains multiple line items that we are currently collaborating on. The purpose of this sheet is to collect the items and publish a requirements document. Part of the collaboration effort is to get all users to cast their votes against each line item so we…
-
smartsheet dashboard is not auto updating
Hi Team, Im leveraging the API to publish data to a smartsheet. Then i have a smart dashboard set up to graph that data. But when i push new data to the sheet, the dashboard charts don’t auto-update.[It says the source is modified but it’s not ...it is the same] I need this to be automatic, so when someone goes to the…
-
Problem Saving Blueprint
Hello Smartsheet, Reposing in hopes that you can assist me. I've added a new sheet to my Blueprint (I've done this before). The sheet has one profile field (Project Name). I don't need anything on the sheet to report out to anywhere. When I try to save my Blueprint, I receive an error "add more column(s) to reporting…
-
Assigning Multiple Tasks to an Entire Team
Hi I am new to Smartsheet, and hence am unable to perform the subject activity in it. I have a set of 25 tasks called "Proofreading Tasks". And I have around 15 people in a team which is called "Team - Proofreaders" . This team is supposed to perform these -- and only these -- tasks. Now how do I set it up in Smartsheet so…
-
forms and cell linking to a secondary sheet
Hello I have created a Time sheet form that i sent out to 11 employees to gather all the daily info. This form fills in the Time sheet Smartsheet. We want to keep the Time sheet Smartsheet as a master sheet and strictly for data collection so that no one messes around with it and looses anyones time. Ive been trying to…