-
Formula not working
Hi , Can anyone help me with this formula issue:- I have 4 symbol color- Not Started- Gray Not Applicable- No color On Hold -Yellow Complete- Green Act1 greater than Act2 and Status is equal to In Progress - Red else Green =IF( Status@row <> "Not Applicable", IF( Status@row = "Not Started", "Gray", IF(Status@row = "On…
-
Return status of cell (blank vs. full) at today's date.
Hello! I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have a vacant/occupied indicator on a SS dashboard. My test sheet is below: So, to determine whether Desk 1 is occupied or…
-
Smartsheet data connection in TIBCO Spotfire server
I am able to create an ODBC connection and get smartsheet data in my Spotfire Analyst client. I followed this link - https://smartsheet-platform.github.io/odbc-docs/#tibco-spotfire-desktop. However, I would like to create an information link and publish data in Spotfire library and share the web link with the users. The…
-
Extract Image using Index and Match/Vlookup
Hey All - Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't work in SS. Additionally, I cannot do a direct link, because we are using the "store…
-
formula not working on row1
Hi , Can anyone help why the formulas are not working on row1.I mean i am not able to use any formula on row1 Thanks
-
Uploading Dropdown Choices from a source file in Data Shuttle
What format does the source file need to be in order for Data Shuttle to upload dropdown choices? I know it needs to be a .csv or Excel file, but what does that file look like? All all values in a single entry or are they delimited? Maybe I am missing something, but this is not very clear to me.
-
Column ID Visual Representation?
We have a sheet with many columns - it can be challenging at times to navigate, given how large it is (unfortunately, necessary for our use case). As standard, there is a built in 'Row ID' or Row counter on the left side of the grid that outlines the row number. Is there any function or feature that could replicate this…
-
Sending approvals through email?
I see that Smartsheet has the ability to let someone know they have a task due by sending them an email with the task details. I am wondering if it is possible to subsequently send an email on Due Date +1 to say "you had this task due yesterday, was it completed?" with a Yes or No button for them to click. If they click…
-
Copying Rows To the Top of Another Sheet
Hi All - Is there any way to use the Copy function, from one sheet to another, and have it copy to the Top of the sheet it's going to?
-
System generated Created (Date) column keeps changing itself to regular Date column.
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I save and re-fresh and it stays for awhile. I've moved around and added and deleted…
