-
Automate RYGB and Children together
I have a standard project sheet. I added one column called Today that in Row1 links to a separate sheet that will be triggered everyday so that it gets Today's date (this gets you around using the Today function which only triggers when a sheet is opened), every row below that first row then has a =CellReference the cell…
-
Is there a way to know current sort criteria?
I got invited to edit a sheet, which I'm pretty sure is sorted. The sheet has way too many columns for me to quickly check the criteria. Is there a way to know what criteria the sheet is sorted on?
-
Overlay Google Calendar in SS in a grid
Im going to implement a time management report in the company to understand how the staff spend their time (meetings, planning, execution, travel, etc) To do this we use a name code in Google Calendar that enable us to automate the analysis, like this. * All meeting start with MEETING... * Task-related to projects starts…
-
QlikView With Smartsheet Connection
Hello Folk's. I have to connect qlik with a Smartsheet table, passing its credencials. I know that there is a connector in QVsoure which is also Qlikview tool, but the company is not willing to spend money on it now Is there a possibility to connect with it via REST? Thanks,
-
Feature Request: Changing Rows in Scheduled Update Requests
It seems as if there's no way to change the rows to be updated in a recurring update request, currently. I think that this is very inconvenient and undermines the power of recurring requests: * I don't want to bother project managers with requesting status updates on already completed rows * I don't want to bother them…
-
Line Item Transfer to Another Sheet using Formula's
I'm working on a project and am hoping for some advice from the community of experts! I have a sheet that serves as an ongoing list of projects and information about those projects - once a decision is made to either fund the project or deny the project, I'd like that line item to appear in another sheet. My main sheet…
-
Updating Old Sheets with Improvements from Newer Sheets
Hi, I have 25 project schedules, some of which are 6 months old. Over those 6 months, I have improved my schedule template over and over. The issue I have now is how to implement these improvements across all of my older templates. For example, I've created conditional formatting with helps with reading my schedule. I'd…
-
Conditions within a Notification
I am building out a notification to send a client updates (daily). One thing the client is asking for is not to see older data (the same stuff over and over). We have an approval date, and if data is more than 3 days old, we want it to fall off the notification. Will the condition in the screenshot below work for what I am…
-
Adjusted Dates Based on the Time a Form is Completed
I am looking to have my automatically set due dates for projects adjust if a request is put in after a certain time of day via the Smartsheet web form. Currently I have a date column where I add a certain number of work days to the timestamp depending on the department that submitted the request that acts as a due date for…
-
Automation from 15 smartsheets to 1 Master sheet
I tried Zapier but ran into two issues. 1. all the sheets must be active all the time.. Zaps will not Zap unless a sheet is inactive. 2. I need the rows added to the master sheet added per division NOT at the top or bottom.. What am I missing? I know that I can copy and paste the rows which is ok.. Just wondering if the…