-
SUMIF Different Columns
Hi, I have two columns [Initial Priced Amount] and [Final Account Amount], what I am trying to do is use the amount in [Initial Priced Amount] if the [Final Account Amount] is blank, but if it isn't blank then use the amount in it, the [Final Account Amount] column. I want to use it in a couple of formulas in other columns…
-
Workflow or Data Shuttle for PowerPoint Document Upload
I've done some research to see how I can have a PowerPoint file automatically uploaded to Smartsheet either via a workflow or via the data shuttle. It appears that PowerPoint isn't a supported file type and figured I'd post here to see if anyone else got this to work somehow. Thank you!
-
Can you assign a random value based on a list?
I am trying to automate the task of assigning a person to an assignment. Users can submit a form, which generates a row on my sheet. The row then has to be manually assigned to someone to complete it. There are no values that can be used to really assign it to one given person- these are submission for setting up new…
-
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…
-
Let folders be folders!
Let at least JPEG/PDF files be uploaded to a folder without a sheet. It is assanin to have to create a sheet to add an attachment that you have to REDOWNLOAD in order to use/export. Why not just allow a folder to have a normal folder use and upload images if I can't even export the attachments off the sheet without having…
-
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…
-
Formula IF/CONTAINS/COUNTIF showing UNPARSABLE error.
I have a sheet collecting answers from a survey. I have 5 columns showing Agree or Disagree questions, one for Team/Role. I want to know the percentage of the level of agreement for each of these 5 questions for each Team/Role. Meaning I want to know the percentage of agreement for Operations, DSIT PMO, etc. I'm trying to…
-
How can I automate/manage the update of URLs included in my dashboards as I provision new projects?
I'm wondering if the URLs included in my dashboards will update with the correspondent new one so as I provision new projects. For example, I have a form URL included in the blueprint dashboard, This URL comes from a sheet also in the blueprint. The ideal scenario will be where everytime a provision a project from control…
-
Transfer Sheet Folders When Merging User Accounts via user management console
Hello Support, Currently sheet folders do not transfer to a new primary account when using the user merge function, please include sheet folders in the current user merge tool within the user management console.
-
Referring to a Cell in Another Sheet that Contains an Hyperlink
I am wanting to refer to a cell (or find a match in a range of cells) in Sheet 1. The cell in Sheet 1 contains a hyperlink. What I get in Sheet 2, however, is just the text in the cell, not the text as a hyperlink. Sheet 1 (contents of cell, text as hyperlink): BUS 123 6Wk Online What I get in Sheet 2:(text but no…
