-
Creating an At Risk Formula
Hello Community, I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the check box column and the Due Date is within the next 3 days. I've made several attempts at using an IF/AND formula, but can't seem to get it to work properly. Any assistance you can provide would be…
-
Sorting Favorites
Hello - Is there a way to sort order of the items that appear in the Favorites section? I don't see the 'Pin to Top' option in Favorites and do not see a way to drag sheets to the top that I would like to appear first. Thanks!
-
TimeStamp Formula Value
Hi, I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry. So for example, if I place an entry on the form, I need for my master sheet to match up my name and the time/stamp data and put it on my master sheet. Any suggestions,…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Document Management Systems
Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their implementations. (how well it integrates with SS, potential problems). It doesn't have…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Formula to return the logged in user
Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODAY(), "")can we have something like =IF(Closed1 = 1, Logged user, "") I know that there…
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
changing email address in contact list (web formular)
Hi everybody, I use a contact list in a web formular. Unfortunately, it is not possible to write a new email address into the drop down list which is not yet included in the list. It simply disappears after writing it + Enter. Is there a way to do so? greetings Joerg
-
Sheet exceeded the maximum recommended size
Has anyone received this error message before? What are the options for large data?
