-
Smartsheet with series of dates representing milestones acheived
i have Smartsheet with series of dates representing milestones acheived. Users enter dates as when they have completed each milestone, How do i measure days between these dates and then put into a dash board /charts depicting what the average days between each point is at each milestone. eg Date of request1 - date of…
-
Approvals, Updates and Deleting Attachment in a Webform during Update
HI there. I am only a month old Smartsheet user and currently under the Business Plan. i am building the New Hire Request Form for our company and I came across with problem in the multiple approval as well as the things to do before a request will be approved. When the requestor filled up the request form, it will prompt…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Formula Help Needed
I currently have 3 Columns: Column 1 "NUMBER OF UNITS", Column 2 "UNIT PRICE" & Column 3 "TOTAL PRICE". What I am trying to do is if in Column 1, the "NUMBER OF UNITS" is 600 or less, I need Column 3 "TOTAL PRICE" to default 515. However, if Column 1 "NUMBER OF UNITS" is more than 600, I need the Column 3 "TOTAL PRICE" to…
-
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…