-
Set Due Dates Based on Day 1 of operation
I am creating a basic task check list that restarts every 4 weeks. I would like to set a task for Day 1 and automatically set all of the future task due dates based on lag time. I am not using predecessors. I would appreciate suggestions.
-
Create RYG Balls for Children
I've spent hours attempting to display RYB Balls for three different drop-down status. "Not Started" "Pending" "Signed" The goal is to have a "Red ball" display in the Not Started Column for the drop down "Not started" in the Quote status children. The formula I'm attempting to adjust - =COUNT(CHILDREN([Quote Status]2 =…
-
Sharing Many Workspaces with Two People
Hi, Attached is a screen shot of my workspaces. Those workspaces that are highlighted I want to share with two people. Is there a way I can send those two people one “sharing email” that will give them access to all these workspaces? Or do I have to send them a separate “sharing email” for each workspace? Please advise.…
-
Stripe Checkout Integration with Smartsheet Form
I have a smartsheet form collecting data for people participating in a conference. I wish to integrate it with Stripe Checkout, so that once submitted, depending on what was checked in one particular box, the Stripe Checkout payment box kicks in and takes over for ticket payment. Can this be done on smartsheet and how to?
-
Forcing a text field if a checkbox is checked (inside a form)?
I don't think this is possible yet but I'll at least ask. I have a change request form generated, if the reason for creating the form is due to a non-conformance i want to REQUIRE the requester to add a NCR# inside the form functionality not on the spreadsheet. Basically it would work as follows. Is this request due to an…
-
CountIFS OR with more than one range
Hi, I am running into some trouble trying to add an OR to a fairly complex CountIFs function. I have tried placing the OR at multiple points, but either get unparseable or invalid operation errors. Here is one attempt: =COUNTIFS({Range 1}, "Color", {Range 2}, NOT(ISBLANK(@cell)), OR {Range 3}, NOT(ISBLANK(@cell)), {Range…
-
Using a datafile to 'autofil' cells
Was wondering if there was a way to upload a external data file (csv) and get it populate cells. IE - Could I load a list of 'Stakeholders' (make it a dropdown list) - and based on that selection from that dropdown list, it automatically fills in another cell, with lets say that 'Stakeholders Manager' So basically 1 cell…
-
Linking to a sheet from a report
I have a report that pulls task from several different sheets. I want to create a link on the report so that I can easily click on the task and it will take me specifically to that sheet that the report is pulling from.
-
% Complete not properly rolling up
Hello All, I am building out a Gantt chart and I have up to three levels of parent rows, with associated child rows, and the sub-parent and child rows are rolling up in their sections, but that isn't rolling up to the next level or the high level. Any thoughts on how I can fix the associations so that % Complete rolls all…
-
Reference to other sheets not changing in countifs when saving folders as new
Hi. I have a smartsheet setup with multiple countifs to other sheets - all within the same workspace. When I save the workspace as new, the references are not changing to the newly created sheets even though I have selected 'Newly created sheets' in the any reports, dashboards, sheet hyperlinks and cell links will refer…