-
Sumif / Countif
Hi All, Still new to SmartSheet so help would be appreciated I am trying to sum a column if another column contains specific text "street lighting" I have come to =COUNTIF(Team:Team, "Street Lighting," ([Past Due Date]:[Past Due Date]) but it comes back with Unparseable and I am lost, It's probably something simple that i…
-
Auto attach emails to Comments on my Smartsheet
Something that would be very helpful is to have a way to automatically attach an email received in Gmail or Outlook to a Smartsheet row by inserting the email into the comments column. The email could reference the sheet and specific row by searching for an existing primary key or some other field on the sheet. Yes, but…
-
Automated Email updates-- SUGGESTING MORE EFFICIENT FORMAT FOR COMMENTS
Hi All-- I LOVE SmartSheet but I really wish the AUTOMATED emails that are sent that include the COMMENTS section could be setup like the emails that can be sent from manually selecting the "send" function on a row; which places the message ON TOP of the row information. Said in a simpler fashion--PLEASE PUT THE COMMENTS…
-
Computing duration from a min and max column
I'd like to support a Min Duration and Max Duration, and then compute Duration as an average of the those two and be reflected in the Gantt Chart. Is it possible?
-
Adding information to templates
I am trying to work out the best way to do this. I have an evolving list of products (hundreds and hundreds) that can be ordered, and 29 people (only - this is set) who can order them for a Bulk Buy once a year. My current plan, was to create a Template, then have a sheet for each person. This way I can request them to…
-
Setup hour by hour plan for the day of migration
Hi, How can I setup a project plan to capture hour by hour activities for migration activity within the day? 1st task will have the start time, then end time and next task start time will base on the data in duration (hours or minutes). Some tasks could be in parallel and others will be in sequences. Still learning…
-
Calendar view of all Projects, the resources assigned to the projects, and their associated allocati
We are looking for a way in SmartSheet to present all projects (ideally, can be sorted/filtered by workspace) and the resources assigned to each project, and the associated allocation in a calendar view. I have created a quick mock up of the presentation attached. No capability to do Reports in the required Calendar view.
-
Adding 30 or 60 days to a date based on another Cell Value
Greetings, I am trying to calculate either 30, or 60 days from a date, depending on the value of another cell. Example: Cell 1: Date Cell 2: $ Value of less than 50k or $ Value of $50k and up Cell 3: Date plus 30 or 60 days, depending on the value of Cell 2. Any ideas? Thanks!
-
Scheduling an Update Reminder like an Alert
This is a test sheet (screenshot attached). I am trying to set up a method to where an Update Request is automatically emailed to the sales rep 3 days after the trigger date (Bid Date). This functionality is in the Alert Module, but in the Update Request you have to manually set a date each and every time; keep in mind I…
-
Sum formula Error When References Results from IF Formula
I am getting an #Invalid Operation error when my Sum formula references a cell with results from an IF formula: =SUM([Column 8]1 * [Column 9]1) results as #Invalid Operation error Column 9 formula =IF([Column 2] = "A", "0.5%", IF([Column 2] = "B", "1.5%")) I've tried to fix by using a nested VALUE= but that does not work…
