-
Formula to count rows in a date range across columns and status
I am getting suck trying to create a =COUNTIF formula from a sheet that has my date column, and several other qualifying status columns.Any advise would be greatly appreciated. Here is where I am at so far and I am getting an #INVALID Data Type error. =COUNTIFS({Sheet1 Range 3}, AND(@cell <= TODAY(), @cell > TODAY(-30),…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
Need Help with a formula
I'm trying to convert an excel spreadsheet to a smartsheet. How would I convert this formula? =IF(SUM(AH6:AL6)=0,,AJ6+$AP6+$AS6+$AT6) Yeah, I am an extreme rookie when it comes to this stuff.
-
Autofill based on the new entry in another sheet
I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill. My case: Sheet 1 (offers) - sales people add data about new offers with the web form (that's OK) Sheet 2 (orders) - I need to bring data from the sheet 1, if offer's status is…
-
Sharing Question -
A workspace was shared with me, and I was made an editor who can share. For a specific SmartSheet in a subfolder underneath that workspace - how do I request to the owner that I want to be an admin of that SmartSheet in order to set up conditional formatting, send automatic alerts, etc.? I do not see any option of making a…
-
Calendars
2 Part Question I want to make 2 employee calendars 1 for vacation another for PTO. Can I create just calendars? I created an installation sheet and a service request sheet. Is there anyway to merge the 2 calendars and color code the installation separate from service request. I would like to be able to view 1 calendar to…
-
Updates are not visible
I have a MSFT- Promo account and a month ago I created recurring Update Requests that are being sent out to my 17 customers. Since the upgrade last week, I cannot find the Updates that I created but they are still being sent out (yes, I checked Alerts and Actions). I keep getting a message "Upgrade to Business or…
-
Notification Dates
Is there a way to edit the dates for when to set a notification past 14 days? We are looking at a way that this can be edited when we need notice 3 weeks in advanced or any specific number of days.
-
Setting up a Notification to send to myself
Hi, I have an issue with Smartsheet and I'm not sure if I'm doing something wrong. I'm setting up a notification through the Alerts and Actions. I want to Smartsheet to send me a notification when one of my users updates a Row to tell me that an Order is being despatched. In the Delivery Settings, I have Shared user or…
-
How to make formulas work on top of a sheet if new entries are coming on the bottom of the sheet via
Hi All I am really stuck with this as I need to amend my fomulas manually every time I have a new entry. Whenever there is a new entry ( via Web-form) I need to change the formula to include the new row instead of helping me with automation it has created extra work for me. Did any of you faced a similar problem? What…
