-
progress percentage cell not accepting formulas
Hi, I have a column to display the percentage of completion for each row, I would like to use something like the below formula in this cell, to automatically update this value, however, Smartsheet is not interpreting this as a formula, instead, is putting a ' sign before the = sign '=IF((Status@row = "Done"), [%…
-
Use smartsheet to autofill / export excel spreadsheet
Hey! Can anyone help with this question: Similar to the "form" function in smartsheet, I can generate a survey-like webpage where users can fill in info for different columns. On the other hand, users want to upload a spreadsheet with e.g. 10 records. My target is to apply the info user filled in in the first "survey"…
-
Automation for changing value to a cell
I wonder if there is a way in which through an Automation I could change the value of a cell,,... not asking for an aupdate,.. I. E. Someone updates Field "Action", and once the pèrson send the update, the field "State" change to the value "Done"
-
Is it possible to send specific columns of two spreadsheets to a third one?
Hi everyone I have two spreadsheets and I want to take some columns of sheet 1 and others from sheet 2 and put them in a third one and that every time an update is made in sheet 1 or 2, it also apply on the third one. Including new rows, deleting rows and changing data. I am working with many data. Thank you, Belia Báez
-
Is it possible to create a personalized email format?
Hi everyone, I want to send an automated email from Smartsheet with some specific information, but I want to give it some specific format to the email just like if I send it from outlook. Thank you
-
RYG Ball Automation - Calculate Program RYG Health based on Project Health
Hi all, I'm looking for a formula to auto-calculate the health of a program, based on 4 components within each of the 4 projects that make up that program. Photo is below of how I have the projects & components set up, along with their RYG indication. You can see they "total up" at the bottom in Overall Program. Can anyone…
-
How to include existing data in a 'copy new row' automation.
Hi! I have a use case where sheet A needs to aggregate data from sheets B, C, D, etc and was going to set up an automation to copy any new rows from sheets B, C, D, etc. to sheet A as specific criteria is met. My question is, if I already had data on sheets B, C, D, etc. how do I get that to copy over to sheet A? Do I need…
-
Copy Row Automation causing duplicates
I am using an automation that copies rows which contain the word "submittal" into a sheet where we are tracking submittal dates for all our projects. I cannot use a report because we need to be able to publish to a calendar. Therefore, the end result must be a sheet. As most of you probably know, these dates can change…
-
Double link from cell in other sheet works erratic
HI, I've created a program management tool where we can manage all our different projects. For the moment i'm working on a Charter approval flow, in different stages. Each project manager has his own Workspace, where all his projects are stored. Everyone has at least viewing permission on all projects. All projects are…
-
Is there an issue with Copy Row Automation?
Hi, I am struggling with an issue (bug?) that doesn't display newly copied data using the copy row work flow function and would like to know if any one has come across this? We have a sheet with vlookup formula which returns some data from a metrics sheet. In this vlookup formula sheet there is workflow which copies this…
