Hi, am creating a smartsheet to collect certain client information & documents to provide a certain service. While creating a form which could be sent to my clients, I've realised that it only allows …
Our security certification requires that we provide answers to several key security questions for every project (risk assessment, project justification, etc) and I was wondering what the best way to h…
I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent…
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called T…
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However…
I've set up a set of three alerts triggered by a date in a column and it's quite lengthy (but works). I now want to eliminate rekeying it to 15 other sheets within the same workbook by copying the ale…
Can you send reminders for upcoming due tasks to someone that is "Assigned to" a task? Currently I just send the automated reminders to shared users but, recently I had the need to just send particula…
I have three "what if" schedules that I'm trying to pull into a single report. They are simply named Scenario 1, Scenario 2, and Scenario 3. No matter what order I select them, the resulting report ha…
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays…