-
We have this one unlicensed user who cannot "Email Comment"
We have this one unlicensed user who cannot "Email Comment." He has "Edit but cannot share" privilege on a few smartsheets. Tried on another browser, another computer. Deleted account and re-created. No success. We have many other uses that can do it except this user. When I click "Send" button, it tries but no new message…
-
How to avoid webhook triggering from cell format updates???
I'm using make.com to do some automations when certain columns in a row are updated. Works great until someone re-aligns the columns and updates 1500 cells at once, sending my webhook 1500 requests. I can filter them out by detecting the actual data cell history, but it still uses 3000 operations for no reason and ties up…
-
Option to include Children rows in Filtered results
I maintain master lists of initiatives in one sheet for each program I'm tracking but not managing. When conducting reviews, I filter the list of initiatives based the stakeholders I am meeting with. Most often, the Children of row item that matches the filter criteria are needed for discussion during my reviews. I…
-
Countifs in date range and value range.
I am stuck on this formula, it doesn't become unparseable but it doesn't result in an accurate count. My goal with this is to is to keep an annual tally of a specific age range of patient the formula is as follows: =COUNTIFS({Trauma Chart Audit Age}, <15) + COUNTIFS({Trauma Chart Audit Age}, NOT(ISNUMBER(@cell)), {Trauma…
-
florin schmanek
The original owner shown on our Smartsheet permission rights as owner has since left the organization how can I change my permission rights from Adm to owner?
-
Formula for Milestone Health
I'm trying to figure out a formula for "Site Health". Each site has 9 milestones that will have a "Milestone Health" column. Each milestone must be completed a certain number of days before the project end date (October 31-22). I don't know how to create a formula to make the milestone health Green, Yellow and Red. At the…
-
How to use OR for COUNTIFS, referencing 2 columns in another sheet
Hi, I have the following formula in a column, =COUNTIFS({Sheet Range 1}, [Column Sample]@row, {Sheet Range 2}, "ABC", OR({Sheet Range 3}, >TODAY(), {Sheet Range 4}, >TODAY() I need to do if column A = 1. column B = 2, (next should be OR) or column C = 3 or column D = 4 Please help out!
-
Extract Date from Modified Date
I am trying to use the Modified Date column in formulas. For some reason, it doesn't appear that this was created as a "Date" column type. Because of this, it cannot be used in any formulas that would allow a date. Is this assessment correct? Also, is there a way of pulling the date out? I've pulled out the Month, Day, and…
-
INDEX MATCH is not pulling correct data even when formula is correct
Hello, for some reason I am having a recurring problem. Well, 2 recurring problems in the same vein. I am trying to pull in data from one sheet to another using index/match. I am positive that this formula is correct because I use it about 100 times throughout all of my sheets. In this particular sheet, this formula is not…
-
Big Time Saver: You Can Now Add Page Permissions in WorkApps
Hi Community, Are you tired of having to manually go into each role and set individual permissions whenever adding a new page to WorkApps? Not anymore! Smartsheet’s new features now allows users to set permissions whenever they add a new page in WorkApps, reducing the number of clicks it takes to change role settings as…
