-
Is there a way to make a Spanish Form?
I have copied the forms to Spanish but the send copy to email is still in English. Is there a way to change that or a Spanish speaking version?
-
Help with Cross Sheet JOIN(COLLECT) formula
I've built a formula to complete a JOIN(COLLECT). If I put the formula on the same sheet as my column references it works just fine, however when I move this to a separate sheet and update the column references to the other sheet I get the error #UNPARSEABLE. From what I can tell I haven't removed any of the formula…
-
Validate Column Data Received in a Form
I have created a simple form to collect the following fields of data: First Name Last Name Email ID number Because a lot of times people are entering information into a form from a mobile device and sometimes have "fat fingers," I wanted to validate the ID column (with a list of users and IDs on another smartsheet). What…
-
Question on Counting days "If"
Hello, In my Smartsheet I have a status column that = "RESOLVED" or "IN PROGRESS" Each row has an "ENTRY" date and sometimes a "RESOLVED" date, if applicable. If a row is "IN PROGRESS" I want it to count the NETDAYS from today, but... If an row is marked "RESOLVED" I would like the NETDAYS function to stop counting.…
-
Nested IF Help
Hello, I have these columns: In a perfect world, when the status changes to RESOLVED, the date resolved would automatically populate. Since I can't do that without the use of something like Zapier, I'm trying to define a workaround using an additional column "Days to Resolve". Some issues have been resolved, but a…
-
Form Permissions?
I don't think this is possible, but I am asking anyway - if it's not possible I would like this added as an enhancement request... I'd like to see forms within sheets be able to be used by specific people only. The current options are basically anonymous (anyone with a link) or an authenticated user (could be anyone with a…
-
Report as a daily reminder.
Hi, I have strange problem. Becouse my coworkers would like to have a report sent daily in the morning. So they can see what tasks (from few sheets) they are assigned to. I already've made those reports and tried to "send as attachment" but it doesen't work (don't know why it isn't sending pdf's like I made it on a…
-
Merged: Alert/notification sender email address
This discussion has been merged.
-
Count Children formula
I have this formula that is working properly except I need to adjust it. Basically what this formula is doing is counting the children rows if a specific date column has nothing (is blank). However, what I need to also adjust for is to have my formula return a "zero (0)" if the units have expired (captured in a helper…
