-
Pivot Sheet & formulas
HI, I've used pivot sheet to gather required information to show up in a sheet. I've attached a clip of the final result which works great except for the fact that I have formulas in some cells. When a new row is created, the formulas in the cells from above don't copy into the new cells. Can someone help me out. thanks!
-
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?