-
Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). What I would like is to have have any rows in the source sheet which match a specific…
-
Sharing Sheets to Multiple Workspaces
I was wondering if I could have a sheet be located in multiple workspaces simultaneously. For example If I wanted to have individual workspaces for each project I am working on, but also have separate workspaces that would allow me to see overviews for ALL projects, all pulling from the same sheets.
-
Smartsheet Reporting - Show Discussions in Report
I would ike to use the Reporting feature so my Smartsheet can also be the Agenda for meetings - eliminates double work - how can i have the Discussion text show on the report?
-
Completed Row Drops To Bottom
Hi everyone, While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on?
-
Embed a smartsheet iframe into Google site?
This seems like a no-brainer, and maybe it has to do more with google's secret jealousy of SS, but why the f*#k can't I embed a SS iframe into a Google Site that I make for the company? This seems like the first thing any joint venture between google and SS would ensure possible. Can you please help?! :-)
-
Limit Size of Entry on a form
I tried to search for this but was not able to find it. I have a form that I has one of the entries that I want to collect is nickname....but I can only display 8 characters.... So how do I limit the entry to restrict it to be only 8 characters? Today I am preloading the field with XXXXXXXX hoping that they will read the…
-
Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
-
Vlookup
Hello, We have here 5 different sheets containing records for Medical service details, including columns for patient name, ID, DOB, charge amount, payment status, etc. Now i want to get a sixth sheet that will look up from the above 5 sheets only the rows that's stated as Denied, so i can view all denied claims in one…
-
Sporatic Error, using the API.
Hello Everyone. I have another weird error. the spread sheet I am making is 35 columns across and 270 rows down. I do batch updates exclusively. And I also time my updates to the most updates are 160 a minute to not overload the Server(a 200 ms delay between updates). sometimes mid way through the updates Im getting *…
-
A Formatting Glitch, using the API.
Hello. I have developed a Script (Powershell), that will create a complete smartsheet. This smart sheet is created with colours based on various times on the source data, (Late, ontime, etc. ). My problem is when I update it again, the first column will keep the shading of the previous entries. even though I specify a…
