-
Help with Vlookup + date
I explain, I need to create an expiration date from a drop-down menu where the different types of payments of my clients are informed. Example, if a customer's account is "up to date" it means that the due date will be the issue date + 0. Also if another customer has a "credit" deferred payment type, the due date must be…
-
pdf and excel files into multiple sheets via Gantt?
Hi there, trying to make a production line more efficient and I need to attach a file to each order (each order is a separate row). We run off of multiple sheets, and have reports broken down to each department. For example: Main Sheet: Gantt Production - includes all orders (which are linked to multiple reports) Report:…
-
Metric format in dashboard
I am trying to display a date in a metric on a dashboard, all the sheets have the date displaying DD/MMM/YYYY but the metric displays DD/MM/YY. How do I get the metric to display the date in the format that I desire?
-
Smartsheet Update for Attachments
#1 - Strongly DISLIKE #2 - Is there any way to go back to the old attachment format window for rows? The new side bar with multiple clicks to download is super frustrating and is not functional for what we do. Bring back the old attachment window please!!!! What used to be a one-click to download is now several. If there…
-
Using Approvals with a formula cell
I am trying to use an approval request to change the value of a cell that contains a formula. The cell that has the formula is based on data in two other cells. For example, the other two cells can either be "Yes" or "N/A". If both of them are "N/A", then my approval cell automatically changes to "Yes" and it does not…
-
Approval workflow
Hi Guys, Im new to smartsheet , please help me. I created an approval workflow then if the approver is not around how I am going to reassign it to other approver without breaking the approval sequence. Please let me know your thoughts. Thank you very much.
-
=COUNTIF field has any value
Hello, My current incorrect statement is as follows: =COUNTIF(Plant:Plant, "DC", [Assigned To]:[Assigned To], NOT(ISBLANK([Assigned To]:[Assigned To]))) I am attempting to count the number of fields with any value in the "Assigned To" column with the plant column being "DC". I have made numerous failed attempts to find…
-
CALENDAR VIEW Date is not showing accurately
Some of our shared users are having trouble with the date showing up accurately in the Calendar view. I cannot seem to find a setting that would allow this to be changed. I have tried refreshing the screen, closing the browser and restarting it. but still they see the dates with Month 7778 example shown in screen shot…
-
Alerts
Hi, I am new to Smartsheet - early indication is it is an excellent piece of software and will help me enormously. I just cant seem to find a way of alerting the assigned to person (of the following task) once the previous task has been marked as complete. I would have thought this was quite a common task but cannot see…
-
Importing rows from Google Forms
Hi, I'm setting up a form in Google Forms to collect data from users. The reason I am doing this using Google Forms instead of the native Smartsheet form solution is because I need to add logic in the form so that some fields become mandatory to be answered depending on a previous selection. Well, the issue I'm facing is…