-
Web Form - Signed
HI all I am creating an onboarding web form however we need the form to have the ability to be signed, I know SmartSheet has an app with Docusign but this is very expensive Does anyone have any tricks or ideas of how this could be done Thank in Advance
-
Nested Formulas issue
Hello all, I am currently working on moving some trackers into sheets from excel and I have hit a roadblock with the following formula which works in excel. I have looked at the template formula sheet and I can get them individually to work however not together. Thank you in advance for any help. =IF(J6>0,"Task…
-
splitting text into multiple rows
Hi there, I am using smartsheet for text analysis and would like to split a cell into separate rows using a return or a full stop as the separator. Any ideas?
-
Automatically copy row to respective category
Hi. I'm using a Web Form to enter data into a page. The page has different columns including Hours Worked, and Category column for the Category drop-down menu selection. With this database, I want the total worked hours for each category. Ideally something like, as soon as you enter the data through Web Forums and it gets…
-
How to Sum Cells with Numbers & Text
Have a super basic question I just can't seem to find a quick answer for. Want to sum cells with both numbers and text in them like "15 min" + "15 min" and get the result of "30 min". I formatted the cell with the following formula: =15 + " min" Result: 15 min When I add 2 cells with that formula [=15 + " min"] + [=15 + "…
-
AVG() returning divide by zero
Hello, I am trying I receive help with making a formula that will take the average of the children rows. I found a VERY similar post, and tried to use that formula, but it did not work. The problem is that I have tried to take the average of the children rows, and display it in the Parent roll. The average is of…
-
request to be able to sort rows while a filter is acticve
I need to be able to sort rows by a certain column with a filter active. now I have to set it to no filter and then sort and then put the filter back on all that is doable but it just seems like it should be able to sort with a filter on.
-
Sending a Row
Is there any way to see the history of ROWS that have been shared? When you send someone an Update Request, its documented in the Update Requests tab with who it was sent to and the date sent, etc. Is there a similar history shown anywhere for the individual rows that are shared?
-
Indent/Outdent
I have over a years worth of indented drop down list worth of info and randomly one day all of the indent buttons disappeared and i cannot open any of the indented drop down lists unless i randomly search something in that list. It wont let me reapply the indent/outdent option either. What do i do?
-
Formulas
I have a drop down text for my second column, I would like to insert a formula that when shipped is selected from the drop down, that it auto checks the check box in column 4 for complete. I have looked through all formula help sheets and can't seem to find this one. Is this even possible? If no, does anyone have any ideas?