-
I can't see/manage my Alerts & Actions
Hello, I have a problem concerning Alerts & Actions. When i first press it in the toolbar I can see that I have 10 Rules. But I can not go further to manage them. Anyone experienced the same problem?
-
Unable to save data to the database
I created a new workflow/smartsheet. Filter seems to be ok and update summary comes up with the correct amount of rows and information. But when I select Save Workflow it complains with !An error occurred, Unable to save data to the database. Anyone else having this problem?
-
Can Barcode Scan return Sheet Data and Auto Complete Form?
Hi! Help!! I'm working on a Sheet to help with our Kanban System. As an employee takes a part from the Kanban Bin, we would them like to scan a QR code of the part taken via a form and the barcode reader on his smart phone, we have set up a test sheet using a lookup table of all parts (on a separate sheet "inventory") then…
-
Date Logic - Weekends versus duration
I'm hoping someone in the community can help me understand the business logic behind the way durations are calculated over weekends in Smartsheet. For context, my sheet has out-of-box settings for working days and hours - Sat and Sun are non-working days, M-F are 8-hour durations. Looking at the attached example, I think…
-
Affixing content to '=PARENT()xx'
Hi I don't seem to be able to affix any text to =PARENT()? I want to have each of 6 child rows as: =PARENT().01 =PARENT().02 =PARENT().03 =PARENT().04 =PARENT().05 =PARENT().06 Any thoughts? Thanks Cheers Richard
-
Conditional Formatting for two end dates
Just to be clear I only have one end date in my sheet. The sheet has a conditional format set up to flag "At Risk" tasks when the end date has already passed. Here's the current formula: IF(AND([End Date]3 < TODAY(), NOT(Status3 = "Complete")), 1, 0) I want to add another condition to flag the task when it is within 5 days…
-
Help with Countif Function Referecing 2 Columns on a different Sheet
I want to be able to see the count of Projects that are assigned to a specific person in one column and have a status of complete in another column. Not sure what I'm doing wrong? =COUNTIF({Master Task & Project List Range 1}, "Crystal Oliver", {Master Task & Project List Range 2}, "Complete") Am receiving "Incorrect…
-
How to combined VLOOKUP and SUMIFS
Hi everyone, I encounter one issue creating formula and linking between two different sheets. I don't know which formula to use but let me share with you what I have done and if you all have a solution to my problem, that would be great. I'm working on a financing sheet, it will be a lot about proposed cost, final cost,…
-
Issue w/ Rules - Being unsubscribed
Is anyone having issues with rules and being unsubscribed? With the smartsheet (server side) issues over the past few weeks, i've had a ton of sheets to re-do all the rules on because there is no global option for that. Anyhow... This week we are experiencing issues w/ the rules unsubscribing users out of nowhere. As you…
-
Commission tracking
Good morning Smart Sheet community. I have been tasked to create a commission tracking smart sheet for our sales team. If you have a pre-fab sheet(s), and willing to share, I would be forever grateful. Otherwise, here was my thoughts on said sheet. First sheet would be for the actual sales. This would have a form available…