-
Progress Bar Automation between 2 Different Sheets
Hi to all you brilliant Smartsheet Wizards! 🧙♂️🧙♀️ I saw a question on here regarding how to "automate a progress bar" and I thought that is perfect for my tracking: Automate the Progress Bar — Smartsheet Community My problem: I want the progress bar in Sheet A under "milestones". But I want it to source the data from…
-
How can I set paragraph line spacing in Document Builder?
I have a series of documents that I have mapped in Document Builder. I need to have the end result with a set line spacing to match the rest of the text from the PDF. I cannot find this setting. I know that I could hard code in the line breaks in the formula, but my issue is that the values in the formula are of variable…
-
AVE or AVERAGEIF when refrencing another sheet
I have my master sheet set up with a duration column. I've been trying to build a formula on my metrics sheet that will allow me to average the duration column based on who is assigned that purchase order. I've tried two formulas, one using AVE and the other using AVERAGEIF and both return the #UNPARSABLE error. The first…
-
formulas to reference sheet in multiple lines
Is it possible to bring information to a sheet from a reference sheet column but have it list the returned information out in separate rows? I have a source sheet with many rows that are sorted by status. I want to list out the job numbers AND the job name in another sheet, ideally side by side one on each row. I would use…
-
Stumped trying to add OR to an otherwise working equation
Hello, I have a working equation that I need to take one step further, but have had no luck with my attempts. I have a Status column that in it's simplest definition needs to return the values "Complete", "In Progress", or " " depending on the values in two other columns; ACTUAL START and ACTUAL FINISH. The list of initial…
-
Merged: Processing Time and Cell/Row Limits
This discussion has been merged.
-
Smartsheet Internal Audit
Hi Community, My Region of our organization is going through SOC2 audit and I am assuming we might be audited on Smartsheet also. I want to ensure that all my teams have updated all relevant Smartsheets and have deleted outdated information from sheets and workspaces. I want to monitor such incomplete or out of date…
-
Creating an At Risk Formula
Hello Community, I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the check box column and the Due Date is within the next 3 days. I've made several attempts at using an IF/AND formula, but can't seem to get it to work properly. Any assistance you can provide would be…
-
Cannot transfer sheet ownership
I am trying to transfer sheet ownership to an existing collaborator who is already an Admin. This message appears "This user cannot accept ownership at this time. Please retain your ownership or select a different user." Any ideas why this can't be done?
-
Two part formula question.
I am trying to count the numbers of cells that have a checked box and have a date within two cells for a training tracking sheet. I am trying to track who has completed assigned training only. I don't want to count the date if it wasn't required. I would like to do it for each row (each employee) and for each column (each…
