-
Attachments
Is there a way to deny being able to check a box complete until an attachment is added. Thanks in advance
-
Identifying a ticked checkbox in an =IF formula
Hi there, I'd like to use an =IF formula to identify those cells where the checkbox is ticked - does anyone know what syntax should be used to identify a ticked checkbox, i.e. =IF(cell = ????,1,0) (where ???? = ticked checkbox)? Thanks, Paul
-
Help with IF formula using Today formula and unparseable error
I have entered the following formula into a text/number column and I'm getting an unparseable error. I have checked the that column headers are spelled correctly. =IF(AND([% Complete]2 < 1, TODAY() >[Finish]2), "At Risk", "Normal")) I want the sheet to check if a task is not yet marked complete (<100 %) AND the current…
-
Requiring Approval when Dates Change
Hello community - I currently have an approval request enabled that notifies me via email once a day whenever a date in the Due Date column is changed. I also have a dashboard that shows me whenever an approval is needed and would like to eliminate the emails coming in to advise me. Is there a way to set up a column that…
-
Administration controls
Greetings, I am looking for advise. I am new to Smart sheets and my Operations manager no longer works for my company and she is setup with all of the administrative controls. I need to gain administrative control of the account. can anyone assist me in this?
-
Cell linking within a sheet
Hi there, I understand that you can link cells in Smartsheet between sheets, but I have been unable to link cells within a sheet - does anyone know if this is possible in any way? Thanks, Paul
-
Streamlining sheets
We have a sales staff that is utilizing multiple sheets, for potentially the same client. I want to rundown the "standard" process to see if anyone can help streamline this. Sales speaks to customer, and enters into SmartSheet, almost as if utilizing like a CRM. This sheet will store details like Name, date contacted,…
-
Approval Alerts & Actions -Column Data visibility
Would anyone know how the approver could view certain column fields? I tried the Advanced Option and checked things off but it still does not show the data in the columns I checked off.
-
Claims Denial Management
Hello. I will be working on building out a claims denial management work plan but was wondering if one already existed within the abundance of templates?
-
count itmes in a column that is populated with multiple data
Hi guys, I have a new challenge for you :) . I have a list of projects. Each project contains different products. I have one probabilty column that contains all the probabilities to sell the different products contained in each individual project. An exaple: I have a project (1 row) where I can sell machines types A, B and…