-
Formula to assign fiscal quarter not working
Good morning, I have been using a formula to assign a fiscal quarter to a row based on a date in another cell. I realized yesterday that the formula isn't working properly. This is the formula: =IF(ISDATE([Estimated Ship Date]1), IF(MONTH([Estimated Ship Date]1) <= 6, "Q1", IF(MONTH([Estimated Ship Date]1) <= 9, "Q2",…
-
If Statement Help
I have a column with 6 options and I am trying to create a statement in another column that says: =IF((Stage1) = "Opportunity", "d73ba1f2-91ba-435e-9480-a2ccf08b36aa", IF(Stage1) = "Contact", "0137cc9c-51b4-40fb-bf06-73174c348733") I have 6 total stages but can't seem to get this to work. Any advice? Geneva
-
Trying to Sum Checkboxes in a primary section of my sheet (not using CHILDREN)...
I'm working on a sheet that will provide me with a team breakdown and weekly breakdown based on checkboxed columns (to make it easier for the end users of the sheet). However, I can't get my formulas to work. (I'm certain that it's due to me being a Smartsheet novice.) I'm attaching a screen capture. Basically, I'm pulling…
-
Write Function that has 2 check boxes in it?
Hi everyone, I have had smartsheet for awhile and finally taking the time to learn/use it and am stuck. I have a custom apparel business and have made a sheet to keep track of all my orders and what the cost will be. I have columns for Quantity, Balance, No Fulfillment (check box), and Paid (check box). I have a working…
-
Removing duplicate types in an output report
I have a report that shows the output of staff within a department. It shows all the publications and events they are working on. I am looking to build the report so that it does not show duplicates of the same type of output by the same person. For example, Staff member A is running 10 roadshow events throughout the year.…
-
Cashflow formula - IF formula issue under date formatted column
Hi, I'm trying to create a project cash flow projection sheet and I'm stuck with the (see attached photo) IF formula. I need the column to be formatted as date to find the IF formula but I cant format the cells below as number/text and I believe this is the reason that the IF formula isn't working. Any help to get this…
-
Send Outlook Calendar invite to Smartsheet to update Calendar
Is it possible to send an outlook invite to Smartsheet to update a Smartsheet calendar? We use Smartsheet calendar to publish the calendar and still have to schedule meetings via Outlook. It would be more streamlined to include our Smartsheet as an invitee to automatically update it.
-
File Upload from Customers
We have recently started using smartsheet to organise our print jobs and workflow through the production line. I am curious to know if a customer that doesnt use smartsheet can upload artwork into our sheet? Can we send them an upload link where customers can upload their artwork (PDF) into their specific row on the sheet?…
-
Automated Reminders
I have a sheet with tasks per row aligned to specific team members. Each row now has a reminder which is aligned with the due date column. Once the team member updates the row with a new due date, there is no new reminder set for the new due date. Can this be done automatically, so that when there's an update entered and…
-
Retrieve deleted sheets
Hi, We accidentally deleted the sheets in our accounts, because we want to change the plan. Case number 02911830 Can you please help us how to get back the sheets that were deleted from "deleted items"? Thank you, Divya
