-
Lock a sheet to archive data
I have a sheet in which we capture each users time on our projects. I will call it the Parent sheet. Each year do a Save As New to start the sheet fresh for the new year. This Parent sheet links to several other sheets that continually change over time. I don't need to track the changes in the linked sheets but I do want…
-
IF statement - How to return a result from two multiple sources
I was wondering if there is a way to do an IF statement to capture a result and add that result into another cell? eg. from A1 (if C2 =“NSW” return “abc computers’ in B2) note - I can’t put the formula in B2 as this a drop down list. the only other alternative would be conditional formatting but smart sheets only gives…
-
Hyperlink in Alert/ Automation
Hi, I would like to add a hyperlink to a Smartsheet report in an alert. The idea is that I want to direct the alert recipients to go to this report to complete a task. Is there anyway to get a hyperlink into the body text of the email alert? Otherwise I need to put the entire url into the body of the alert, and the…
-
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
-
SUM cells with formulas not working
Hello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's column with numbers. This formula in the second sheet is asking to SUM some of the numbers in the first sheet's column and divide…
-
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…
-
Can a smartsheet form autopopulate a PDF? Or can you push every row to a recreation of the form (in
Hi, We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form submission to populate a PDF? Or link cells in smartsheet to a PDF? Or any other…
-
Creating multiple ranges without formula
I have inherited PMO reposinsibility for a large program in Smartsheets. I am going through the process of linking the various schedules, finance/risk/issues registers and other sheets for about 15 projects, all of which link into sub-programs and then up to the overall program. Is there any way that I can go into an…
-
Max Cost per Year
I need to determine the max Remediation Cost PER Year. I also, need to pull this information into another sheet's cell. What's the best way to go about this? This is the formula I have thus far, but it's coming out UNPARSEABLE... =MAX(IF([Date of Incident]:[Date of Incident], <=DATE(2020, 12, 31), [Date of Incident]:[Date…
-
Workflow and cell linking.
I have two sheets that have linked cells. I want to use the workflow to make the tasks from the second sheet disappear if the Status column says complete. Is this possible? I know how to set up a workflow to move cells to a new sheets but it does not seem to be working. Is this because I have the cells linked to another…
