-
IMAGE transfer to OTHER ROW/COLUMN using Formula?
Hello, Is there any way or formula I can use to transfer a Jpeg/Png file to other row without uploading it or using a formula? For example, I have Sample.jpg in my [1st Column / 1st Row] and I want it to transfer/copy that picture into my [2nd Column / 1st Row]. Thanks.
-
Statistical functions with if testing
it will be helpful to have statistical functions like Max, Min, Average etc combined with IF functionality like Sumif, Countif. Currently I have to create one column for first doing the if function in one column and then use statistical functions on the result column. When there are multiple fields it necessitates lot of…
-
Filters and sharing as an Viewer
We have a new user with with Admin privileges to their workspace. Their workspace has a sheet and a report. Their report includes data from their sheet, which they need to be able to edit from the report, but needs to also include some data, from another sheet in a workspace that we do not wish to share with the user. They…
-
Cards - Can we have support fro split columns
I was watching a video the other day on Microsoft Azure (https://azure.microsoft.com/en-us/resources/videos/242/). There they detailed the ability to have split columns under a single swimlane header. This allows you to further sub-divide the tasks within a category. Is this supported in SS? If not can it be as this would…
-
Persistent formula cells
MS Project has a lot of built in features that SmartSheet just doesn't have. Such as calculating if something is late, setting a deadline that flags if the date moves, calculating AWC and SWC, etc. To that end I have created a bunch of hidden cells that do all the needed functions and checks, and then built the…
-
IF(OR) Help needed
Hi All - I'd like to use a formula to evaluate status of red OR yellow then flag if red or yellow. I think I'm close but it's not working, please help. Here is what I have: =IF(OR([Status6] = "Red", [Status6] = "Yellow"), 1) (doesn't work) =IF((Status7 = "Red"), 1 (this works for red and sets the flag on for reporting…
-
Tablet Web Forms (How to?)
I have an Android Tablet (don't judge me). There is a section for Web Forms. How do I add a Web Form to the list? I searched the Help Center without finding an answer. Craig
-
Copying numbers inserted by Auto-Number
I want to be able to copy the numbers inserted by Auto-Number. I use them to create a control number for each row/record, which I want to then place in external systems for correlating notes and files. However, the numbers inserted by Auto-Number don't seem to lend themselves to being copied once they've been created. I…
-
Auto Update Request based on email contained in a specific column
I have a sheet of 30 rows and would like to send daily email Update Requests based on an email in one of the columns. These people are not in my contact list. Is there a way to 'bulk' issue this command for all 30 plus rows or do I have to issue 30 commands. Hope this makes sense. John
-
Auto Fill Values based on existing values
In Excel, if you have a column that has say values such as "CAT", "HAT", "MAT"... If I am going down row-by-row and start typing "M" then this prompts you with the option of hitting enter or click to choose the work "MAT" as this already exists as a value in the column Does anything like this exist within SS?
